I have a base with 2 tables. Table 1 is my “Contracts” table, Table 2 is my “Renewals” table. Both tables contain a field “contract n°” Every time a contract is being renewed an extra record is entered into the “Renewals table”
I have now imported my existing data in the 2 tables.
I don’t see how I can automatically link the 2 tables. I want to be able to click in table 1 and then get a view of all renewals for that contract only. I have far to much data to individually select records fom table 2 using linked record fields.
I’m probably missing out on something?