K
Karen
I have a project that I'm working on designing and have a thought. I was
wondering if it's possible to do the following:
tblQC holds Quality Control results on our bulk product.
tblfillrecord hold records of where those bulk products were used.
These tables have the bulkcode and lotnumber in common.
When the bulk product is made the raw materials used to make that bulk are
recorded (code and lot#) in tblQC. When the bulk product is poured into
bottles to sell the bulkcode and its lot# are recorded in tblfillrecord
along with what size bottles, the qty of bottles, fill date, etc.
I want to be able to search for a raw material by code and lot# and list
what bulk's it was used to make (no problem here) and list them on a form.
Then (here's the question) can the user click on one of the records on the
form and drill down to see where the bulk was used?
Does anyone have any idea if this can be done and a few pointers in the
right direction?
Karen
wondering if it's possible to do the following:
tblQC holds Quality Control results on our bulk product.
tblfillrecord hold records of where those bulk products were used.
These tables have the bulkcode and lotnumber in common.
When the bulk product is made the raw materials used to make that bulk are
recorded (code and lot#) in tblQC. When the bulk product is poured into
bottles to sell the bulkcode and its lot# are recorded in tblfillrecord
along with what size bottles, the qty of bottles, fill date, etc.
I want to be able to search for a raw material by code and lot# and list
what bulk's it was used to make (no problem here) and list them on a form.
Then (here's the question) can the user click on one of the records on the
form and drill down to see where the bulk was used?
Does anyone have any idea if this can be done and a few pointers in the
right direction?
Karen