Form Design - Multiple record lookups

[luv2birdie]

I need to create a return merchandise authorization form in our db to track returned products (under warranty). We will be using two tables. One to look up the original record of the product sold - serial and part number and update a RMA table with return details (RMA #, Date, reason and warranty yes or no). i have attached a visual of what I would like it to look like. I need to have up to 20 entry lines to enter up to 20 products that can be returned at once. I would like some ideas from the support community as to how i should set this up. FYI - we have a very large database >25,000 records. We would identify each product by the serial number (primary key in products table). We would like to open the form and scan the serial number of the product in to the first box in the first columns of each line.
So...
Scan first item in serial number box, auto populate the part number from the products table associated to that serial number.
Then enter in a reason for return and select yes or no under warranty.
The RMA table will have to be updated with RMA #, Date, reason, warranty.
If there are multiple products returned I need to go to the next row and repeat the process.
Any help would be appreciated!


Jen

 

[llkhoutx]

The return reason can properly be store on the same table/row as the return. New return, new row, new reason.

Multiple returns, same reason, use a combo box for the reason with a NotInList event to save new reasons.

 

[JHB]

.. i have attached a visual of what I would like it to look like. I need to have up to 20 entry lines to enter up to 20 products that can be returned at once. ...

Use a subform, then you can enter as many you would need.