Help approaching problem - form input of product - send to multiple plant locations

[June7]

Db has forms with names:
frmInputPlants
tblInputProducts
tblProductConstituentDetail Subform

Only the first one works.

My initial inclination would be to have a structure that relates Constituents to Product and Products to Plant. But you have a requirement to differentiate Constituent requirements by the source Plant. Gets complicated. Looks like you have a handle on that.

[illicited]

Your looking at the latest attachment I posted right? From this morning?

[June7]

Yes, downloaded an hour ago.

"The record source 'qryPlantProductsDetail' specified on this form or report does not exist."

And taking another look at the query list I do see that query.

Could be the issue is I am running the db under 2007. The db does give me incompatibility warning when I open it. Will have to try again later under 2010.

[June7]

Just downloaded the db. Running under 2010. Still get the 'record source does not exist' error. I try to open the qryPlantProjductsDetail in datasheet and get error "The Microsoft Access database engine cannot find the input table or query 'tblPlantProductDetails'." There is no table called tblPlantProductDetails.

[illicited]

Ok sorry about wasting your time, I'll take a look at that.