Duplicating a record and related records

[Greg Hains]

Hi.

I have a small problem that I need a hand with please. It's more about my lack of knowledge than anything.

I have two tables. One is QUOTES and one is LINEITEMS.

One of the fields in QUOTES is the Quote_Number, and the same field name is found in LINEITEMS.

There are numerous records in LINEITEMS that are related back to QUOTES.

I am looking to duiplicate a record in QUOTES, includuing all the LINEITEMS records associated with that quote.

What is the most efficient way to duplicate this record, bringing the a copy of the LINEITEMS across with it.

Thanks in advance,

Greg

[bcooney]

http://fmforums.com/forum/topic/64943-duplicate-record-and-sibling-records/page__view__findpost__p__307966

[Greg Hains]

Thanks BCooney - to my rescue yet again. :)