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
Thank you for prompt answer.
I actually did the first idea already. Regarding the second idea how can I create a report link to both in one link.
But i have a bigger issue that I want to filter on one facility in a report and see everyone related to that facility even corporate.
I was thinking along the lines of having another table that links contacts and facilities and will map all of the corporate contacts to the facilities. My issue was to automatically create those records. One major reason for this is that a corporate level contact can possibly be related to only some related facilities and not to others.
I actually did the first idea already. Regarding the second idea how can I create a report link to both in one link.
But i have a bigger issue that I want to filter on one facility in a report and see everyone related to that facility even corporate.
I was thinking along the lines of having another table that links contacts and facilities and will map all of the corporate contacts to the facilities. My issue was to automatically create those records. One major reason for this is that a corporate level contact can possibly be related to only some related facilities and not to others.