Serious issues.....

[JustMaybe]

Okay I have the following problem …which I can’t even think how to solve….

I have an order table with a subform …’order details’..each line has an detail ID

I need the order form to have the option to pick from previous detail ID’s (order detail records)…which will generate the chosen record onto the current orders subform. Then the user can overwrite that particular record!!!


Does anyone have any ideas as to how I can even start to consider dealing with this issue???

Thanks so much in advance if anyone has any ideas to address this issue

The prob is that each product has a serial record..this is renewed each year with a new serial number……

 

[llkhoutx]

Put detailID in a combobox to pick the one you want; then, on AfterUpdate, stuff that record into your subform.