Using a field in one table to create the primary field in another

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?

1 Like

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?


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.


1 Like

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.