A
Andy
Hi;
Just spent the last 35 minutes searching Microsoft tech support for:
Append Query.
Using Acc2000.
When a Quote turns into a Sale:have to copy data from table "tblQuoteMain"
and its related sub-table "tblQuoteSub" to "tblSoldMain" and its related
sub-table "tblSoldSub".
..
"tblQuote*" Relationship: QuoteMainId, One-To-Many, Enforce Referential
Integrity, Cascade Update & Delete on.
"tblSold*" Relationship: SoldMainId, One-To-Many, Enforce Referential
Integrity, Cascade Update & Delete on.
I know that an Append query will copy the data from the "Main" tables
correctly.
But what about the "Sub" tables?
What needs to be done so that the related data in a sub-table arrives in the
proper sub-table of an appended table?
Oh; the search results from Microsoft "Help", and I use that word "Help"
loosely, number 43 was:
Query Modem Operation Appends Output to Log File Even Though the "Append"
Option Is Not Selected
I searched Access Support for "Append Query"
Thank You.
Andy
Just spent the last 35 minutes searching Microsoft tech support for:
Append Query.
Using Acc2000.
When a Quote turns into a Sale:have to copy data from table "tblQuoteMain"
and its related sub-table "tblQuoteSub" to "tblSoldMain" and its related
sub-table "tblSoldSub".
..
"tblQuote*" Relationship: QuoteMainId, One-To-Many, Enforce Referential
Integrity, Cascade Update & Delete on.
"tblSold*" Relationship: SoldMainId, One-To-Many, Enforce Referential
Integrity, Cascade Update & Delete on.
I know that an Append query will copy the data from the "Main" tables
correctly.
But what about the "Sub" tables?
What needs to be done so that the related data in a sub-table arrives in the
proper sub-table of an appended table?
Oh; the search results from Microsoft "Help", and I use that word "Help"
loosely, number 43 was:
Query Modem Operation Appends Output to Log File Even Though the "Append"
Option Is Not Selected
I searched Access Support for "Append Query"
Thank You.
Andy