Hi,
In the Accounts table I have added a multi choice column (Category) that allows multiple choices. These options (among others) are Supplier & Customer.
I am now working on the Products table and want to add a single choice Column for Supplier but want the options to be from the Accounts table where Category column above may include the selection "Supplier"
Is this possible? Maybe with a view?
Thanks in advance for any assistance
Todd