I am creating an inventory database and each entry has an individual invoice # and a few other informative fields. Quite often there will be 20+ entries with consecutive invoice #s and all other fields will be indentical. Is there any way to enter these records into a table without having to enter each invoice one by one.
I was also wondering if their would be a way to make a form button that would duplicate that record for the next record only adding 1 to the invoice #. Kind of like an optional autonumber.
A solution to either of these dilemnas would make my database a success. I have a feeling these problem are very basic, but I have been only using access for 2 days.
I was also wondering if their would be a way to make a form button that would duplicate that record for the next record only adding 1 to the invoice #. Kind of like an optional autonumber.
A solution to either of these dilemnas would make my database a success. I have a feeling these problem are very basic, but I have been only using access for 2 days.
