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.