G
Guest
New to access. Trying to have a parameter qry based on user selection from a
combo box, but the table referenced is a link table for a many-to-many
relationship. I'm struggling to figure out what the row source should be for
the cbo.
tblProduct
pkeyProductID
strProduct
tblProcess
pkeyProcessID
strProcess
tbllinkPlan
fkeyProductID
strProduct
fkeyProcessID
strProcess
pkeyPlanStep
strPlanArea
I want a cbo on a form that asks the user before running the query what
strProduct to select. What should the row source SQL be?
combo box, but the table referenced is a link table for a many-to-many
relationship. I'm struggling to figure out what the row source should be for
the cbo.
tblProduct
pkeyProductID
strProduct
tblProcess
pkeyProcessID
strProcess
tbllinkPlan
fkeyProductID
strProduct
fkeyProcessID
strProcess
pkeyPlanStep
strPlanArea
I want a cbo on a form that asks the user before running the query what
strProduct to select. What should the row source SQL be?