I have 2 tables - call them Data1 and Data2. Let's say they each contain a list of contracts. Some will be on both tables, some will be only on one, some only on the other. The purpose is to compare two data sources and check for contracts that exist in only one source. They both have the same fields, although with slightly different names:
Contract1
Year1
Department1
Premium1
Losses1
and the same for the 2nd table, just with a 2 instead of a 1.
I want to set section access by department. I'm linking the 2 tables on Contract and Year - I created a field called Cont_Yr in each table which is Contract & Year.
Originally, I was only using the 1st table, and I'd used the Department field for section access. Now that I'm adding the 2nd table, how can I set section access for Department2 as well? Can I just add another field to the section access called Department2? Or will that limit the access to where data exists on both tables so they both match up?
