Solved: Copy Functionality - Page 2

JayG · 12-28-2023 11:56 AM

Hello All,

Following is my data structure:

1) Master - Table (Quotation)

2) Multiple Child Tables that makes up 1 Quotation (having common Quotation ID) which in turn as multiple records

The ask is to have "Copy Quotation" functionality.

Can you please suggest how this can be best accomplished?

Denny774

Hey,

you gotta create that Temp-ID in the Original Record first (Create a new (physical) Field for that and name it Temp-ID or Template-ID or Temporary-ID or whatever. Otherwise you would never be able to know what new Quote-ID was created for the new (copied) record, which in turn you need to know (while copying) to process and assign the Quote-ID (Temp-ID) to the child items 😁

View solution in original post