Linking Records causing creation of multiple columns

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?

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.

  • “buyer agent” = Dusty
  • “seller 1” = Sam
  • “seller 2” = Ralph
  • “title” = Cheryl
  • “escrow” = Deidre

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 :slight_smile:

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

1 Like

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