linking 2 tables and bldg a query

  • Thread starter Thread starter kim
  • Start date Start date
K

kim

I want to be able to link two tables and have the user
select the brand they want and then the second drop down
poplulate the flavors we have. I have two tables they
each have a linking field of product code. What is the
best query type to use (make table, lookup, etc.)? Any
suggestions on how to get this data out there would be
great.
 
I want to be able to link two tables and have the user
select the brand they want and then the second drop down
poplulate the flavors we have. I have two tables they
each have a linking field of product code. What is the
best query type to use (make table, lookup, etc.)? Any
suggestions on how to get this data out there would be
great.
Click to expand...

I'm not sure what you're asking. For one thing, you do NOT need "make
table" queries if you have the data in existing tables; for another,
you should avoid the Table Lookup feature (see
http://www.mvps.org/access/lookupfields.htm for a critique).

If you want to have two Combo Boxes in which the choices for the
second combo depend on the value selected in the first one, you can do
this on a Form. See http://www.mvps.org/access/forms/frm0028.htm for
sample code. I don't think there's any way to do this in a Table
Datasheet, but then you really should routinely use Forms rather than
datasheets in any case.
 
Back
Top