Criteria on a concatenated field

[Guest]

Here's my situation. I have a table (Call Log) with a field (Contact) that
pulls data from a second table (Subkcontractor Contacts). The data that's
pulled is from 2 separate fields and is concatenated into one field. (First
Name and Last Name are joined together) When I try to do a query where I
have a box pop up to enter what criteria i want to query, it wants me to
enter the primary key for the field 'Contact'. I want to be able to enter
the contact first and last name. Even better, I would like to have a drop
down list box to choose from. Can anyone help me?

Thanks in advance.

SVE

 

[Guest]

Here's my situation. I have a table (Call Log) with a field (Contact) that
pulls data from a second table (Subkcontractor Contacts). The data that's
pulled is from 2 separate fields and is concatenated into one field. (First
Name and Last Name are joined together) When I try to do a query where I
have a box pop up to enter what criteria i want to query, it wants me to
enter the primary key for the field 'Contact'. I want to be able to enter
the contact first and last name. Even better, I would like to have a drop
down list box to choose from. Can anyone help me?

Thanks in advance.

SVE

Well... why are you storing the contact information redundantly in the
second table at all? That's simply neither necessary nor good design.
Typically the call log table would store just a numeric ContactID, as a link
to the Subcontractor Contacts table. You could use a Combo Box based on a
*query* concatenating the name for display, and storing the ID; this could be
set up either to store the ID, or to find a record for that ID.