Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 01, 2024 05:06 PM
I have two bases: Contacts and Matters. In Contacts, there are two tables: People and Companies. In Matters, I have a table (Matters) with a field for Clients. I know i can sync People and Companies to the Matters base. However, is there a way to link the records for People and Companies to the Client field? I only see a way for one or the other.
Solved! Go to Solution.
Apr 01, 2024 05:23 PM
Ah, I see! A single linked field can only link to a single other table I'm afraid, so that isn't possible. Maybe you could create a single table that includes the data from both the "People" and "Companies" synced tables?
Apr 01, 2024 05:16 PM
After you've synced the "People" and "Companies" tables to the "Matters" base, you could then create two linked fields from the "Matters" table to the synced tables? Sorry, I think I'm not understanding your problem!
Apr 01, 2024 05:21 PM
I want to have one linked field. In Matters table, I have a field called Clients. In Clients field, I want to be able to pull up data from either People or Companies. But when I try to link to another record, I can only choose People or Companies. I cannot choose both.
Apr 01, 2024 05:23 PM
Ah, I see! A single linked field can only link to a single other table I'm afraid, so that isn't possible. Maybe you could create a single table that includes the data from both the "People" and "Companies" synced tables?
Apr 01, 2024 05:48 PM
I see. I was hoping otherwise. Yes, I thought about creating a single table, but was seeing if the other way could be done. Thank you for the help.