Two of same field (different rows) in same query

[Guest]

Hello,
I have a table which contains all of the contact info of which along
with FirstName and Last Name, I have a ContactType. I have line item tasks
that the employee types need to be assigned to the customer types. I have
created a table consisting of an Empevent field as the primary and the
ContactId to represent the customer but I am having issues assigning the
ContactId for the employee to the row (causes errors). I sure would
appreciate an idea or two as I am STILL new to the wonderful world of Access.

Thanks.

 

[John W. Vinson]

Hello,
I have a table which contains all of the contact info of which along
with FirstName and Last Name, I have a ContactType. I have line item tasks
that the employee types need to be assigned to the customer types. I have
created a table consisting of an Empevent field as the primary and the
ContactId to represent the customer but I am having issues assigning the
ContactId for the employee to the row (causes errors). I sure would
appreciate an idea or two as I am STILL new to the wonderful world of Access.

Thanks.

If the Empevent table has just one contactID, that means that only one contact
can be involved with an event. Is that what you want? Could you explain *how*
you are "assigning the contactid for the employee to the row" and what errors
you get? We're not there and can't see your screen...

John W. Vinson [MVP]