Unanswered: multiply entries in a table created by single entry on a form?
What I have is a small form that basicly looks like this :
Product : <product entry>
Date Recieved : <date entry - automaticaly entered>
Number of pallets : <number of pallets entry>
Add Product <button>
What I need to be able to do is have some code enter the entries for "Product" and "Date Recieved" in an existing table (which has more fields than just these) x number of times dictated by the number in the "Number of pallets" entry.
Is this possible and could someone point me in the right direction to make it work?
if you can calculate this information you don't need to store it. All you seem to be doing to useing up diskspace for no real end. Unless I have missed something you may need to reconsider the way you want to record the data.
Remember a database is the Base of data from which you get information.
It isn't really a calculation. What it is for is in our production facility, when we recieve batches of raw materials, we need to be able to track each individual pallet or drum from coming into the plant to the material being used and the container disposed of.
When we get materials in, it is somewhat large quantities and the shipper/reciever doesn't have the time to enter them all in. What I want to be able to do is have a form or some data entry page where the S/R enters something like " recieved 35 drums of chemicalAQ " and have 35 entries of chemicalAQ produced in the table as well as the date recieved and a unique idetifier or barcode for internal use. I can create the unique identifier, but not the multiple entries withour the S/R entering each one.
I guess if worse comes to worse, I could just make her click an add to inventory button as many times as needed to get the information in, but I would like to stay away from that if possible.