The best way to design a data entry web form
Hello,
I am trying to build an Inventory application and I have an existing form that is used to enter information about materials that are shipped to our warehouse into a table named parts.
The problem is if I receive 5, 10, 20, or more items, I have to enter them one at a time using the existing form. I would like to know a way to enter a number of items received into a field named "# of Line Items" and if I enter a number such as 10, the grid view or table will display 10 data entry rows where I can use dropdown boxes to automatically fill in all related fields for items that will have the same Part Number, but different, Part Serial Numbers.
Correct me If I am not thinking correctly, I am thinking that I will have to modify the existing form with a grid view linked to tblparts, but not quite sure how to get the number of rows generated that --I have been searching the internet, but have not found an example or article yet.
Design Goal Example
**************************
RecivingID______ ______# of Line ITems
Part# | PartSerial# | PartName | Qty | Remarks
--------------------------------------------------------
1.
2.
3.
4
5
Thank you in advance,
|
