K
Kirt84
I have posted a question related to this but still have not found a
solution….help would be greatly appreciated.
I am trying to create a batch processing sheet (using Forms) for my company
which they use to make checks before they label medicines
I have a Product Details table which I have created a Form with. This is
purely a look up table therefore when the Primary key ‘ECMA’ number is
searched for it will automatically populate all related fields – Product,
Pack size, Details etc.
I then have a second table Form Details where details about the product are
entered and stored in the database. These tables are linked using the ECMA.
The ECMA number is a foreign key in this table as the same products will
undoubtedly need to be labelled again. The Form details has a unique field
called ‘Batch number’ which is an Autonumber, therefore a certain batch can
be searched for again in case there is any discrepancies with the product.
The Form runs off the Product Details table and I have made the Form details
into a Query which is then made into a Subform. What I want to be able to do
is only print one record – on the actual Form or on a Report.
solution….help would be greatly appreciated.
I am trying to create a batch processing sheet (using Forms) for my company
which they use to make checks before they label medicines
I have a Product Details table which I have created a Form with. This is
purely a look up table therefore when the Primary key ‘ECMA’ number is
searched for it will automatically populate all related fields – Product,
Pack size, Details etc.
I then have a second table Form Details where details about the product are
entered and stored in the database. These tables are linked using the ECMA.
The ECMA number is a foreign key in this table as the same products will
undoubtedly need to be labelled again. The Form details has a unique field
called ‘Batch number’ which is an Autonumber, therefore a certain batch can
be searched for again in case there is any discrepancies with the product.
The Form runs off the Product Details table and I have made the Form details
into a Query which is then made into a Subform. What I want to be able to do
is only print one record – on the actual Form or on a Report.