Add many records based on another table
I am trying to create a database of many contacts. We service many medical facilities which each have many contacts. Most of these facilities are part of a corporate company. On a corporate level ther...
Forum Discussion
There may be a simpler way if the corporate contacts are to show on each facility contact list. I thought that different corporate contacts appear on different facilities. But I think that this solution still has two report link fields.
Have a table of Contacts.
1 Corporation has Many Contacts.
1 Corporation has Many Facilities
1 Facility has Many Contacts
On the Facility record you would show a report link field where the where Related Corporation matches the Related Corporation of the contact. Then you would also have a Report link field where the Record ID# of the facility matches the Related facility on the contact record..
Have a table of Contacts.
1 Corporation has Many Contacts.
1 Corporation has Many Facilities
1 Facility has Many Contacts
On the Facility record you would show a report link field where the where Related Corporation matches the Related Corporation of the contact. Then you would also have a Report link field where the Record ID# of the facility matches the Related facility on the contact record..
This is what I currently have. But this would limit me when i want to relate a contact of a corporation to only some of its facilities and not to all.