searching multiple fields at the same time for different keywords

[Shannan Casteel via AccessMonster.com]

I have job codes that require me to provide several text boxes for people to
list the codes they have used. I want to be able to use the FIND dialog box
to search through these fields, but there is a twist. I need to be able to
enter two job codes at once. For instance, I have 14 text boxes for the job
codes. If I have entered job code 1000 in text box #1 and job code 2000 in
text box #2, and this occurred in more than one record, how could I search
for any record that contained job code 1000 and job code 2000 at the same
time. I've been told by an engineer who has done some consulting in Access
that there is nothing wrong with my table structure.

Someone please help!

Shannan Casteel

 

[Rick B]

You were told wrong.

This is a one-to-many relationship.

If your record has five job codes associated with it, it should have five
record in a separate table. If it has ten codes, it should have ten
records.



TblCustomer?
CustomerNumber
CustomerName
CustomerAddress
etc.


TblJobNumbers
JobNumber
JobDescription


TblCustomerJobs
CustomerNumber
JobNumber



The first table would have one entry per customer

The second table would have one entry for all possible job codes

The third table would have one entry for each Job Code done by a customer.
This could be one record, ten records, or no records for any give customer.

 

[Rick B]

I guess it'd really be a many-to-many relationship.


--
Rick B

You were told wrong.

This is a one-to-many relationship.

If your record has five job codes associated with it, it should have five
record in a separate table. If it has ten codes, it should have ten
records.



TblCustomer?
CustomerNumber
CustomerName
CustomerAddress
etc.


TblJobNumbers
JobNumber
JobDescription


TblCustomerJobs
CustomerNumber
JobNumber



The first table would have one entry per customer

The second table would have one entry for all possible job codes

The third table would have one entry for each Job Code done by a customer.
This could be one record, ten records, or no records for any give customer.



--
Rick B

I have job codes that require me to provide several text boxes for

people

to
list the codes they have used. I want to be able to use the FIND dialog box
to search through these fields, but there is a twist. I need to be able to
enter two job codes at once. For instance, I have 14 text boxes for

the