REF OR LIST
Hi, i’m building an app for the invoices. In my app there are CUSTOMERS TABLE and LOCATIONS CUSTOMERS; the customers could have 1 or more Locations; In The INVOICES TABLE i would like to chose the LOCATION of Customers, i tried to insert REF- LOCATIONS CUSTOMERS and SHOW IF = CONTAINS([LOCATIONS CUSTOMERS[CUSTOMER],[CUSTOMER NAME]) but it shows all LOCATIONS CUSTOMER.
How can i resolve it? +Steve Coile