B
BIll
I am using a database to collect information on part
production. This information is input into the database
to calculate productivity. The raw material is cut and
made into one part number. That information is entered
into the form. The raw material that was not used because
it was too short is made into a different part number. I
want to be able to input each part number, but have them
as separate entries in the table. I also want to maintain
information from the first entry like machine number,
date, etc.
I have tried to go to a separate form to input the
additional part number, but got an error message that you
are at the end of a record set. The method I tried would
not maintain the information of machine number, date,
etc.. How can I handle the two and possibly three or four
different part numbers into the tables?
production. This information is input into the database
to calculate productivity. The raw material is cut and
made into one part number. That information is entered
into the form. The raw material that was not used because
it was too short is made into a different part number. I
want to be able to input each part number, but have them
as separate entries in the table. I also want to maintain
information from the first entry like machine number,
date, etc.
I have tried to go to a separate form to input the
additional part number, but got an error message that you
are at the end of a record set. The method I tried would
not maintain the information of machine number, date,
etc.. How can I handle the two and possibly three or four
different part numbers into the tables?