G
Guest
Hello in advance,
I have four tables: Contacts, Company, Title and Relationship. The table
Contacts, Company and Title are my primary tables, I want to append all the
ID's from each table into the table Relationships. This way i would have all
ID's and could create a Relationship ID for the combination of ID's appended.
So it whould look some what like this:
RelationshipID ContactID CompanyID TitleID Date
1 4 2 7
=Now()
I have four tables: Contacts, Company, Title and Relationship. The table
Contacts, Company and Title are my primary tables, I want to append all the
ID's from each table into the table Relationships. This way i would have all
ID's and could create a Relationship ID for the combination of ID's appended.
So it whould look some what like this:
RelationshipID ContactID CompanyID TitleID Date
1 4 2 7
=Now()