Reflecting in list recently added values in table

[dejhantulip]

Hello everyone!
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!!!

[Rafael_ANEIC-PY]

Hello @dejhantulip, welcome to the appsheet community !

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

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.