In my ‘Properties’ table - I want to add all the details relating to my property including Seller details, Escrow company etc, which I want to link from my Contacts table, but it is causing multiple ‘properties’ columns in my Contacts table when I feel like it should all appear in the one column?
Link to my base and also screen shot of multiple columns. You can see the same property keeps appearing under a different columns and this seems super messy
See link to my base
Hi @Elizabeth_Auctions
I don’t have access to your base. Is it possible to share a new link?
Hi @Elizabeth_Auctions
I don’t have access to your base. Is it possible to share a new link?
this should work?: Sign up - Airtable
Hi @Elizabeth_Auctions
I thought this would be the problem. Every time you link a field in table 1 with table 2, it creates a new field in table 2. As far as I can see, you have 5 field in table 1 that are linked with a person in table 2, hence the (at least) 5 fields in table 2.
So, if you say a “property address” has Dusty (linked record) as an buyer agent in table 1, Dusty will have that address with his name in table 2 in a field that you could call “buying agent for”.
Hope this makes sense 
You could make seperate tables for separate roles: one for the sellers, one for the buying agents, etc. Than you wouldn’t have all those fields in one table.
Hi @Elizabeth_Auctions
I thought this would be the problem. Every time you link a field in table 1 with table 2, it creates a new field in table 2. As far as I can see, you have 5 field in table 1 that are linked with a person in table 2, hence the (at least) 5 fields in table 2.
So, if you say a “property address” has Dusty (linked record) as an buyer agent in table 1, Dusty will have that address with his name in table 2 in a field that you could call “buying agent for”.
Hope this makes sense
You could make seperate tables for separate roles: one for the sellers, one for the buying agents, etc. Than you wouldn’t have all those fields in one table.
Okay I understand, thanks for the different table idea. Appreciate your help
I have a similar problem only I don't think that's the solution for me as I have people, companies and content in separate tables, so I'm not sure why every time I link people to their companies or content (i.e.: authors to their books, film directors to their movies, etc.), I inadvertently create redundant columns (i.e.: "Content copy," "Content 2 copy" and so on).
Not quite sure what I'm doing wrong but I'm really getting tired of the unnecessary grunt work of repeatedly scanning, parsing, merging and deleting these extra columns - over and over again.
Any ideas?
Beuller?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
