Hello.
Im putting together a database for which I need you help and advice.
I receive a box of Bolts, each has a plastic jacket and each jacket has a sequential number from x value to y value. We receive them in batches batches of between 500 and 1000 at a time.
I need to record each bolt number received and add that to a table, but dont want to add each bolt type, date received, supplier, manufacturer etc 500 to 1000 times, that will take forever. I have a form, I want to enter the generic data, but add a start range and add an end range, and then something to then add the number of records I need. so: Bolt Start Range, Bolt End Range, enter the generic data, click a button on my form and 500 sequential records are added to the table.
This is so my staff can then log out individually numbered bolts and add them to the indivdual suppliers they send the individual bolts to.
I can also stock check the remaining quantiy.
I just need a way to do the aboe.