November 24, 201114 yr 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
November 24, 201114 yr http://fmforums.com/forum/topic/64943-duplicate-record-and-sibling-records/page__view__findpost__p__307966
Create an account or sign in to comment