Reflecting in list recently added values in table

Hello everyone! :slight_smile:
Quick question… So I have a Customers table (very simple, just the customers’ names) and a Sales table which has a date, the customer’s name (which comes FROM the Customers table) and the price of the sale.

Basically what I am trying to do, is that whenever I add a customer’s name to the Customers table, this new name is reflected and available for selection when I go over to Sales.

See what I mean?
Is this possible?

By the way, in the Sales table I have the customer’s name set up as a LIST and the formula is =CustomerList[CustomerNameColumn] which makes sense in my mind, however the list is not reflecting the newly added customer.

Please help me out.
Thank you!!!

Hello @dejhantulip, welcome to the appsheet community !

What you want to do can be done using references, please check out the following link:

1 Like