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
Select List: Showing Unique Values, and Showing Items from a Non-Display Column	2	438	September 26, 2023
Retrieve all selectable items from a list column	3	1371	December 29, 2018
Column Type - Lookup Table - How to display 2nd column in lookup table instead of 1st	3	307	April 15, 2022
Table view of unique values from a specific column	1	1956	November 26, 2019
Lookup & select list from a detail display	3	542	November 10, 2019

Lookup Table with Unique Names Only

Related Topics