Linking tables & List box

[Guest]

Hello,

I am creating a database where I have 3 tables so far,
Employees, Customer, Tracking information.

None of them are related to each other - no primary key in any of the
tables. What I am trying to do is in
Customer Table - I have a field name called Unit (A,B,C), Primary Category,
Secondary Category. Depending upon the unit selected, it will bring a look
up list for primary category(from Tracking Info table), and depending upon
primary category selected, it will bring up the list for secondary category.
Tracking Information - This table has all the values, has all possible
scenarios.

Basically, Primary category is a text with the look up list box, Row source
type Table/query, and the query is not showing the right result.

Oops that was a big post, but if anyone can help or have any suggestions, it
would be greatly appreciated.

 

[Guest]

You say "None of them are related to each other" yet in turn your UNIT is
related to Tracking information table.

Post the table structure of the tables and the SQL statement of the query.
Also some sample data from the tables and say what you want to have in the
query results.

 

[Guest]

Hi Karl,

Sorry I mean to say I have not set up any relationships among table.
Customer Table:
Fields: Unit (2 value: New Install, Repair)
Primary Category
Secondary Category

Tracking table:
Fields: Unit
Primary category
Secondary Category
(Unit, primary category, secondary category) in both tables are identical
Tracking Table
Unit Primary Category Secondary Category
New Install Field Work Appointment Missed
New Install Field Work Equipment Missing
New Install No Field work Due date missed
New Install No Field work No facilities available
Repair Field Work Reschedule
Repair Field Work Cust equipment problem

In the customer's table, there is drop down for Unit. So lets say if I
choose New Install, for the Primary Category in Customer's Table, I want the
drop down menu with only 2 options, Field Work, No Field Work. Then if I
choose, Field Work for Primary Category, I want Secodary Category to have
drop down menu with two options, Appointment Missed, Equipment Missing.

So dependig upon cust input for Unit, it will decide what should be in drop
down menu for Primary Category. customer table should be getting the info
from the tracking table.

To do this for Primary Category, it is text book with look up value list
box, Row source type is table/query, I am not sure how to write the query, so
depending upon Unit, it will show only options that are avaialable for that
unit.