2 queries with link table

  • Thread starter Thread starter Piperlynne
  • Start date Start date
P

Piperlynne

I need to know the best way to do this.
I have a table (tblBrand) that includes the primary key BRAND and a table
(tblItem) that includes the primary key SKUPLANT. I have a link table
(tblLINKBrandItem) that has both these fields plus a autonumber as primary
key. (Brands can have multiple items and Items can have multiple brands.
I have forms (frmBrand and frmItem) and am trying to create a command button
that when you are in the brand form, will query and show the items related to
that brand. I am pretty sure I need 2 queries and a macro or two to get this
to work, but I'm hitting a brain block and can't quite figure out the right
way to approach this.
Suggestions?
 
I am pretty sure I need 2 queries and a macro or two to get this to work,
Yes, first query for tblBrand to use for main form.
Second query having tblItem LEFT JOIN to tblLINKBrandItem on SKUPLANT for
use in the subform.
Set the Master/Child links of form/subform using BRAND.
Have a combo box in subform to select item.
 
Back
Top