PLEASE help me with parameter queries & table relationships!!!

[Red]

I am designing a database to keep track of the jobs we have done for our
clients. I would like users to be able to search the database using parameter
queries.

My tables are structured as follows:

Clients (Client ID, Client Name)

Industry (Industry ID, Industry Name)

Employees (Employee ID, Employee Responsible)

Project Type (Project Type ID, Project Type)

Jobs (Job ID, Client [drop-down list from Client table], Industry [drop-down
list from Industry table], Project Type 1 [drop-down list from Project Type
table], Project Type 2 [drop-down list from Project Type table], Project Type
3 [drop-down list from Project Type table], Job Description, Year, Employee 1
[drop-down list from Employees table], Employee 2 [drop-down list from
Employees table], Employee 3 [drop-down list from Employees table], Work
example

I have made a parameter query where one can enter a Client name, and it
brings up a list of all jobs done for that Client (shows all fields in Jobs
table). Have done a similar query to search by Industry. These work fine.

I would like to be able to search by Employee Name, but so far the query
only returns Employee Names in the Employee 1 field. How do I get it to also
pick up the name if it's in Employee 2 or Employee 3 fields?

Would like to do the same for Project Type but am having the same problem as
there is more than one Project Type field.

My tables are related as follows:

Industry ID (Industry table) = Industry (Jobs table)
Client ID (Clients table) = Client (Jobs table)
Employee ID (Employees table) = Employee 1 (Jobs table)
Project Type ID (Project Type table) = Project Type 1 (Jobs table)

I am suspecting the problem lies with the last 2 table
relationships....would appreciate any advice!!!!!!!!!!!!!!!!!

 

[Nikos Yannacopoulos]

Answered in the Getting Started newsgroup.

Pls don't multi-post! If necessary to post to multiple groups (which is
rarely the case), then pls cross-post instead (a single post to several
groups), so it's easier for you and everyone else to follow the thread
(each subsequent reply shows in all cross-posted NG's.

Nikos