Relationship question
I have 2 tables, Companies (Clients) and Vendors (both contain data but no relationships setup between them). On the Companies table I have several fields I want to pull a Vendor name into...
Archive Vendor
Software Vendor
Portfolio Vendor
Etc.
On the Vendor Table I want it to have a field with all the names of the Companies...
In other words if I enter Vendor X into the Archive Vendor fields for each of the three separate Companies and then go into the Vendor Table under Vendor X I should see all 3 Companies Names there as well.
Of course it would be even better if it worked both directions...
If entered into Companies fields automatically stored in Vendors
If entered into Vendors fields automatically stored in Companies
Archive Vendor
Software Vendor
Portfolio Vendor
Etc.
On the Vendor Table I want it to have a field with all the names of the Companies...
In other words if I enter Vendor X into the Archive Vendor fields for each of the three separate Companies and then go into the Vendor Table under Vendor X I should see all 3 Companies Names there as well.
Of course it would be even better if it worked both directions...
If entered into Companies fields automatically stored in Vendors
If entered into Vendors fields automatically stored in Companies