I have this table, which shows all the different Units I can build. When I select the dropdown, however, the list that it offers is really really long. [image] How can I make this only offer the unique Unit Types from other unit tables? The Unit Data Table I am pulling from looks like this: [i…

Looks like you’re getting good help here but on the point of “transition a column to a lookup column”, there’s a little trick for how to do it without doing a lot of work: [image]

Lookup Table with Unique Names Only

Ander February 20, 2019, 5:15pm 7

@cnr

More tables are better than fewer tables.

You probably need at least one more table.

Topic		Replies	Views
Dynamic select list items based on a lookup column	4	4055	January 17, 2020
Lookup from Table vs Selectable List	12	3896	March 20, 2019
Automatically Updating Select List Contents Suggestion Box	7	2442	February 22, 2019
The never ending saga of look-up vs select lists, and more potential differences	9	2507	December 12, 2019
Is it Possible for a select list to be selected only once?	13	2691	December 10, 2022

Lookup Table with Unique Names Only

Related topics