Auto create duplicate of parent & child records

[Marc G]

I need to create duplicate records of both a parent record and related child records.

The parent dB is "proposals" and the child dB is "line items" for the proposals. My salesmen want to be able to create a duplicate proposal with all the line items and then modify the line items to create an alternate proposal for the customer.

How can an automate the process so at one click they can:

1. create a duplicate of the parent records (with a new proposal# auto indexed)

2. Create a duplicate set of all the related line items with the duplicates assigned the new proposal number.

I've tried a few approaches, but have hit a roadblock on every approach. Any help is appreciated.

Thanks

[BobWeaver]

See this post:

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB8&Number=1463&page=1&view=collapsed&sb=5&o=all&fpart=1