Proper use of Multiple Table design?

[hitechartist]

What would be my best approach to do the following?




I need to use just one form for the following.


Lookup item in one table.(Item #)
When found copy some fields (Description, Price) from that found item in the table and put that information onto the same form, I'm currently on BUT
I will need to have that info that I'm displaying put into a different table.


Once it's displayed, I may have to do one of the following:


Look up another item and display it on the next line, same as above.


I may have to hit a VOID button to remove one or more of the items, not in any particular order.


When I'm done entering items this way I will need to copy these line items to another table and clear this table and the items being displayed on this form.


Any idea's on the best route?

[June7]

Options for search/filter:

1. http://www.datapigtechnologies.com/f...tomfilter.html

2. http://www.allenbrowne.com/ser-62code.html

Why do you need to copy to another table and 'clear this table'?

Does VOID mean just delete the record or retain record and show VOID in some field? Select sequential records and hit keyboard Delete key. If you want to disable Delete and use custom command button, code is somewhat complicated.

Asking for a lot of info. Really need to deal with one issue at a time. One topic per thread. When you encounter specific issue, post attempted code for analysis.

[ranman256]

I use a list so the user can dbl-click the item in tInventory. It adds it to the client subform tOrders.
Since its a recordset, you just delete the record to remove an item, or change the qty.