Skip to main content

I’m wanting to create a blank table and the primary field to be all the single selects from another table in the same base.


Ideally, I’d also like the table to update when a new single select is added. Is this possible?

Well, let me answer your second question first: not just possible, but likely. Okay, almost certain.


But it’s the first question I’m unable to answer, because I don’t understand what you’re trying to do. Any chance you could be more concrete – tell us exactly what sort of data you’re working with?


William


Hi @Cora_Harrison,


Following the answer from @WilliamPorterTech, you can change the single select field to a Linked Field and choose Create New Table. This will make a new table with the primary field the items in the single select AND you now can lookup values in both tables.


BR,

Mo


Reply