I have a Company table which contains following fields :
Type 1 FLAG
Type 2 FLAG
Note : Each company can flag 1 or both types
I also have a Business table which contains following fields
Responsible Type 1
Responsible Type 2
For each Business, I need to identify the Responsible Type 1 & 2. I would like to do this based on a value list which uses the Company_Names from the Company table. I also would like to make sure that for Responsible Type 1, the values shown are only companies where Type 1 FLAG is "1". Same for Responsible Type 2 based on Type 2 FLAG.
I already did several tests but I do not manage to make the value lists work correctly.
Do you know how I should set this up?
Thanks in advance for your input?