ok. I’m confused…
I have 2 tables:
Category_Table with 2 fields - Category and Sub Category. The data looks like this:
Sales_Table has a bunch of fields but it also has Category and Sub Category. I can do a lookup from list on the Category by saying =Category_Table.Category.Unique() and it works perfectly.
But how do I have a select list that uses the Sales_Table.Category value from Category_Table?
Any help would be appreciated!