Multiple Record entry on a single form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am attempting to design a database to, among other things, log the production of widgets. I have created a table with fields for the following; Operation(auto-number), Widget number, part installed, part serial number, employee. The operation number is simply to keep future entries in some order. However, I'd like to enter historical information as well. I would like to create a form to enter the widget number once and to automatically list all my part numbers so a user can simply enter in a serial number and employee for each part #. Is this possible?
 
Rob in Philly said:
I am attempting to design a database to, among other things, log the
Click to expand...
production of widgets. I have created a table with fields for the
following; Operation(auto-number), Widget number, part installed, part
serial number, employee. The operation number is simply to keep future
entries in some order. However, I'd like to enter historical information as
well. I would like to create a form to enter the widget number once and to
automatically list all my part numbers so a user can simply enter in a
serial number and employee for each part #. Is this possible?
One table for the Widgets and one for the parts in the widget.
Relate them and use a form for the widgets and a subform for the parts.
The Northwind Database has similar examples of this. Order with details,
brands with products...
 
Back
Top