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
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 :slightly_smiling_face:
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.