Im trying to design a new databse. We receive a box of 1000 sequentially numbered bolts which we attach to individual customer containers, and sent out into the world. Im required to log the bolts in, which come into us in batches of 500 to 100, and go out as individuals.
I need to record the box contents when it arroves, but want to add the box id number, each bolt number in sequence and the supplier, which is a combo box, but I dont want to type in the data 1000 increasing the bolt number value by 1 manually. I want to fill in a form, enter the star range, enter the end range, click a button and on cllick code updates my table 1000 times with the sequentail bolt numbers so i can then individually allocate the out,
I just need help with the above. Some of the fields I have are below for the table and what i have for the form so far.
My Table is called TblSEALS and has these fields
BoxID = Number
BoltNumber = Number
Supplier = Number (relationship to Lookup a company name)
My presentl unbound form with add button is called FrmSEAL
BoxID (ser defined)
BoltStartRange (user defined)
BoltEndRange (User Defind)
Supplier (ComboBox)
Your help is very much appreciated.
I need to record the box contents when it arroves, but want to add the box id number, each bolt number in sequence and the supplier, which is a combo box, but I dont want to type in the data 1000 increasing the bolt number value by 1 manually. I want to fill in a form, enter the star range, enter the end range, click a button and on cllick code updates my table 1000 times with the sequentail bolt numbers so i can then individually allocate the out,
I just need help with the above. Some of the fields I have are below for the table and what i have for the form so far.
My Table is called TblSEALS and has these fields
BoxID = Number
BoltNumber = Number
Supplier = Number (relationship to Lookup a company name)
My presentl unbound form with add button is called FrmSEAL
BoxID (ser defined)
BoltStartRange (user defined)
BoltEndRange (User Defind)
Supplier (ComboBox)
Your help is very much appreciated.
