N
ngincolorado
I'm building a database for an organization that has many members companies
and contacts for each company. Some of the individual companies that are
members are part of a parent company, but they all pay for their own
memberships.
As a result, the same contact person can exist for multiple companies. On a
company form I created I have a subform that displays and edits all of the
contacts for that company. On a contact form I created I have a subform that
displays and edits all of the companies for that contact.
I don't want the same company to have duplicate records, nor do I want the
same contact to have duplicate records, but I need to find a way to establish
relationships and data-entry forms that allow me to both add contacts under a
company using the autonumber unique ID assigned for each contact and company
entered both ways. Right now the relationships and forms let me do the
contact under company easily, but I've not figured out how to add multiple
companies to the contact without creating a duplicate company with a new
unique ID#.
I am leaning towards making a sub-subform with search/auto-fill code to do
this, but I'm not sure about the structural integrity that may compromise the
database, or just do it manually with periodic cleanup of duplicates on the
backend. Any suggestions on how to construct these relationships?
and contacts for each company. Some of the individual companies that are
members are part of a parent company, but they all pay for their own
memberships.
As a result, the same contact person can exist for multiple companies. On a
company form I created I have a subform that displays and edits all of the
contacts for that company. On a contact form I created I have a subform that
displays and edits all of the companies for that contact.
I don't want the same company to have duplicate records, nor do I want the
same contact to have duplicate records, but I need to find a way to establish
relationships and data-entry forms that allow me to both add contacts under a
company using the autonumber unique ID assigned for each contact and company
entered both ways. Right now the relationships and forms let me do the
contact under company easily, but I've not figured out how to add multiple
companies to the contact without creating a duplicate company with a new
unique ID#.
I am leaning towards making a sub-subform with search/auto-fill code to do
this, but I'm not sure about the structural integrity that may compromise the
database, or just do it manually with periodic cleanup of duplicates on the
backend. Any suggestions on how to construct these relationships?