T
tbl
When dredging up older data from two tables that *should*
have been related but weren't, I've managed to get them
related, and spiffed up for appending to the linked tables
in my current db.
What I'm unsure about, is whether or not I need to do the
append in steps, or if I can do it all at once.
My level of expertise only allows the two step plan, where I
would append the main table data first, and then be able to
fetch the autonumbered Id field value (the new key) to
update in the child table (using the old keys), and then
append that one.
Is there anything better, short of pages of code that make
my hair catch fire?
have been related but weren't, I've managed to get them
related, and spiffed up for appending to the linked tables
in my current db.
What I'm unsure about, is whether or not I need to do the
append in steps, or if I can do it all at once.
My level of expertise only allows the two step plan, where I
would append the main table data first, and then be able to
fetch the autonumbered Id field value (the new key) to
update in the child table (using the old keys), and then
append that one.
Is there anything better, short of pages of code that make
my hair catch fire?