Skip to main content

I've tried searching this, but can only find where people link two tables, then manually add the relationships for each record.

This is my situation.  I have two tables.  One is a list of addresses (123 main st, 234 main, 345 main, etc) and also has owner name (multiple addresses can have the same owner), the other table is owners and info like phone.  

I wanted to just link the two tables by owner, so in the owner table, if I click the owner name, it will show all the properties they have.  When watching videos, it seems I have to do this manually by adding each building to the respective owner.  Is there a way that I just link the table and it happens by itself?  I have thousands of records so I can't do it one by one.

Yeap, try converting the field that contains all the owner names into a linked field to your "Owners" table:

This should automatically link everything like you want!

 

Thank you.  This did work.  I'm not sure why it wasn't working before, but I rebuilt the tables, did this, and it works fine.

Reply


Terms & Conditions