Repeat Question

[Access form problem]

I have created an personal MIS for my self use . I am into sales job . My
job is to pick the orders from customers . For Ex say i have picked single
order for 5 different items at 5 different rates . Each item is further
having their unique technical specifications . Say if specification is typed
; some item will finish in 2 lines while other will take 40 lines . My
problem is how to define the entry form at run time that i need to enter 5
items or N items so that 5 times or N times only entry scheme comes before me
and all are related to an single order only . Pls help this .

Thanks

 

[June7 via AccessMonster.com]

Assume table for Customers and table for Items.
Need data entry form with RecordSource query of the two tables.
Textboxes, comboboxes, listboxes on form bound to the appropriate fields of
RecordSource query.
Use form navigator to add record, as many times as you need to.