G
Guest
Hi, I hope someone can help with this....
We have a table of customer contacts, a table of our company's folk, and a
table of resellers. I am trying to put together a table which pulls this
information together to capture correspondence between the groups.
The correspondence table has a date for each transaction, a type (EMAIL,
PHONE, etc), notes about what was said, a field for what customer is being
considered, and 3 potential FROM fields which look up their data from the
various tables (FROM US, FROM A RESELLER, FROM THE CUSTOMER) it also has 3
potential to fields (TO US, TO THE RESELLER, TO THE CUSTOMER) also linked to
the tables.
My dilemma is that we often cc correspondence to several resellers. It's
awkward to put them all in the field TO THE RESELLER separated by commas, in
fact, I can't get a form to allow me to select multiple resellers. Clearly I
am missing something here.
Also. I'd like to just have a single field called FROM that includes all the
potential people the email might be from (resellers+customers+us) and a
single field called TO (same idea).
I wait eagerly for any clarity you good folks can provide.
Thank you
Diane Meriwether
We have a table of customer contacts, a table of our company's folk, and a
table of resellers. I am trying to put together a table which pulls this
information together to capture correspondence between the groups.
The correspondence table has a date for each transaction, a type (EMAIL,
PHONE, etc), notes about what was said, a field for what customer is being
considered, and 3 potential FROM fields which look up their data from the
various tables (FROM US, FROM A RESELLER, FROM THE CUSTOMER) it also has 3
potential to fields (TO US, TO THE RESELLER, TO THE CUSTOMER) also linked to
the tables.
My dilemma is that we often cc correspondence to several resellers. It's
awkward to put them all in the field TO THE RESELLER separated by commas, in
fact, I can't get a form to allow me to select multiple resellers. Clearly I
am missing something here.
Also. I'd like to just have a single field called FROM that includes all the
potential people the email might be from (resellers+customers+us) and a
single field called TO (same idea).
I wait eagerly for any clarity you good folks can provide.
Thank you
Diane Meriwether