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?
Using a field in one table to create the primary field in another
+2
+19Well, 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
+17Hi @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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.