Form/ filter for report

[vaa571]

Hi,
I have a simple database with the following table:
Main Table – fields - Pack Serial Number, Board Serial Number, Lot Number.
I have form to enter the data by the operators at my production line as they
construct the packs, the board is bared inside the pack and is not visible
once the packs is sealed. The packs serial number is visible. I need to
generate a report after the packs are final inspected by our QC group. How
can I create a form so QC can scan the pack serial numbers and populate or
save the records to be used later on a report so when they are done all I
need to do is print it out? This report must shown the “pack serial number
and its board serial number†remember QC does not know the board serial
number because it is bared inside of the pack. However this information has
being recorded by production line in the main table.
What I am doing is creating another table with all the packs scanned by
final inspectors and populating the board serial number information using a
select query and use the query as record source for my report. It just seems
a lot of work and if I am not around no ones know how to do this.
Thanks for any help

 

[Fred]

A few questions / clarifications:

Are there more than one boards in a pack? To keep this moving, let's
temporarily assume not.

Your "what I am doing....." sentence is confusing or mixed up (including
that select query does not populate data in a table) and so we're not getting
any info from that sentence.

I think that you are implying that a pack passing QC is an event that the DB
needs to record (plus probably some ancillary data such as the date / time
that it passed) and that such is a filter or sort criteria for reports.

Also assuming that you don't want your QC people to search for / verify the
record of the pack that the production people have created. Otherwise you
could just add the QC info fields to the "main" table that was loaded by the
production people and heve the QC find / verify the record, and then add the
QC info to the record.

If above guesses are right.

Have the QC create a record which has the pack serial number plus any QC
info. The join the two tables (PackSN to PackSN) andf create your reports
from that.

Hope that helps a little.

Fred

 

[vaa571]

..Hi Fred,
Your suggestion is exactly what I am doing now, when I mentioned that on my
post “what I am doing…†this is it; I have QC creating another table with the
pack serial number only. Then I created a select query that joints the “Main
table†and the “inspection table†and the query results shown the information
I need and my report is based on this query. The problem is when I not around
they don’t know how to do this.

To answer your questions, there is only one board in each pack, but QC
cannot see this information, it is inside of the pack.

I like the idea of have QC search for/ verify the record and thenadd their
information. I can add the QC field to the Main table. Do you think I should
use the date and time when each pack has passed QC inspection as ancillary?
Not sure how to do that, and also how can I set the criteria later in a Query
to generate the report? I probably have to create prompt form so when the
operators open the report they are asked to enter [lot number] [pass/failed]
[inspection start date] [inspection end date], am not sure if I got this
right. Appreciate your input again on this. Thank you.