S
Slushpump
I have a number of contacts. I also have a second table, with a number of
groups. In each group, I have an "owner", "alternate owner", and a number
of "members" (01 thru 10). I want to not duplicate all the email addresses
in the group table, but refer to the existing email address in my contacts
table.
So I'm attempting to record only the contact ID in each of the groups
fields, then display the email address in the form (rather than the contact
ID).
I'm an absolute rookie with access, but have some sql background. Can this
be done? My contacts reconciliation process will ultimately (try to) mail
out the groups details to their primary contact for verification/update, then
I'll send out emails to every contact to verify their details.
One contact may be in multiple tables; possibly in different roles.
Am I missing something easier than attempting to do this with the office
2007 template?
groups. In each group, I have an "owner", "alternate owner", and a number
of "members" (01 thru 10). I want to not duplicate all the email addresses
in the group table, but refer to the existing email address in my contacts
table.
So I'm attempting to record only the contact ID in each of the groups
fields, then display the email address in the form (rather than the contact
ID).
I'm an absolute rookie with access, but have some sql background. Can this
be done? My contacts reconciliation process will ultimately (try to) mail
out the groups details to their primary contact for verification/update, then
I'll send out emails to every contact to verify their details.
One contact may be in multiple tables; possibly in different roles.
Am I missing something easier than attempting to do this with the office
2007 template?