I'm trying to create a form that will document serial numbers that are used.
What I want is a form where I can fill in static information like date and
workorder# along with the beginning and end of a serial# series and have it
create records for each serial number that contains all the static
information.
Well... the first thing to realise is that a Form is not the right
tool for this. A Form is just a window, a tool which lets you edit and
manage data which is stored in Tables. You will indeed need a form,
but the *first* thins is to come up with a table structure as the
foundation for your database.
You don't say exactly what "workorders" and "serial numbers" have to
do with one another, but it sounds like you need a table for each.
Given that, you should NOT (emphatically not!!) repeat the static data
for each serial number; that's neither necessary nor beneficial.
Assuming that one Workorder can be related to multiple SerialNumbers,
you might have a Workorder table (with one record per workorder, and a
WorkorderNumber as its Primary Key), related to a table with just two
fields - SerialNumber and WorkorderNumber. A Query joining these two
tables would let you display the static data together with the serial
number.
What information (other than the number itself) needs to be recorded
for each serial number? Or do you just need the information that
numbers 10225 through 10324 were used on Workorder 836?
John W. Vinson[MVP]
