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

[Cora_Harrison]

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?

[WilliamPorter]

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

[Mohamed_Swella1]

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