C
Charles
Alright, I know I have this all screwed up but let me try to explain the
problem once again.
I am trying to duplicate a record that is divided into records in a table
called tblInvoices and detail records in a subtable called
subtblInvoiceDetail These two tables are joined in a one-to-many
relationship using two fields as the primary key; numTrxID and numTrxType.
Basically, here is what I am trying to achieve. In this sales environment,
sales people generate a Transaction ID that starts an order. The numTrxType
field defines what type of transaction type it is (Quote, Invoice, or
Cancel). That means the same TrxID could have 3 different TrxType's.
Therefore, if a sales person generates a quote a month ago and now wants to
invoice it, rather than having them reenter all the data I want them to push
a button that will make a copy of the "Quote" record from tblInvoices and
the corresponding "Quote" records in the subtblInvoiceDetail. The sales
person will then change the TrxType to "Invoice" and I want this to change
the TrxType in both tables for that record. This is not happening. The
subtblInvoiceDetail portion of the record is not being duplicated.
How do I duplicate a record from both tables to create a new record in both
tables?
Hope this clears it up.
problem once again.
I am trying to duplicate a record that is divided into records in a table
called tblInvoices and detail records in a subtable called
subtblInvoiceDetail These two tables are joined in a one-to-many
relationship using two fields as the primary key; numTrxID and numTrxType.
Basically, here is what I am trying to achieve. In this sales environment,
sales people generate a Transaction ID that starts an order. The numTrxType
field defines what type of transaction type it is (Quote, Invoice, or
Cancel). That means the same TrxID could have 3 different TrxType's.
Therefore, if a sales person generates a quote a month ago and now wants to
invoice it, rather than having them reenter all the data I want them to push
a button that will make a copy of the "Quote" record from tblInvoices and
the corresponding "Quote" records in the subtblInvoiceDetail. The sales
person will then change the TrxType to "Invoice" and I want this to change
the TrxType in both tables for that record. This is not happening. The
subtblInvoiceDetail portion of the record is not being duplicated.
How do I duplicate a record from both tables to create a new record in both
tables?
Hope this clears it up.