Duplicating an Order (and all its parts)

[Meltdown]

Hi all,

My client wants a 'duplicate order' button so he can use previous orders as a 'template' for new orders.

Duplicating the order itself is no problem using a 'Select' query to select the order, and an Append query(based on the select query) to insert the duplicate order.

Similarly the line-items in the sub-form can easily be duplicated using the Select/Append method as each line-item will have the orderid as a foreign key.

My problem is when there is a 'details' button (or in my case, an RD button) for each line item in the sub-form. I need to be able to duplicate whats behind each RD button and then append it to the correct line item in the new record sub-form.

Has anyone ever done anything like this before?

Thanks

Regards
Melt

 

[Premy]

Well I'm sure that almost anything can be done with data that has been saved following minimal normalization requirements. But to be able to help u out, one must have a rather clear idea about your data structure and about what u want to achieve. Means you have to elaborate more and be more specific.

HTH