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
It sounds like you may have a Many to Many requirement for those Corporate Contacts.
One Corporate Contact has many Corporate Contact Facility Assignments
One Facility has Many Corporate Contact Facility Assignments.
So you would need to set up a middle table called Corporate contact Facility Assignments.
One Corporate Contact has many Corporate Contact Facility Assignments
One Facility has Many Corporate Contact Facility Assignments.
So you would need to set up a middle table called Corporate contact Facility Assignments.