Text field shared value with a condition
Currently, when people are filling in a form for table A, the Contact selection drop down is filtered based on the Chosen company. Contacts are kept in table B. Occasionally there is a third party com...
Forum Discussion
Normally I don't recommend making more than one relationship between two tables, but this might be a good exception.
Create another relationship where each Table B (Contacts) has many Table A. And rename the relationship so you can easily keep it separated from the main relationship.
Then once you add the other field to your form A, you will want to make a custom report that will be used as the record picker on the form.
So on your contacts table, make a report that only shows the contacts from your 'primary' company.
Then use that report for the record picker on form A.
Create another relationship where each Table B (Contacts) has many Table A. And rename the relationship so you can easily keep it separated from the main relationship.
Then once you add the other field to your form A, you will want to make a custom report that will be used as the record picker on the form.
So on your contacts table, make a report that only shows the contacts from your 'primary' company.
Then use that report for the record picker on form A.