Append to two different tables
Thanks, again. I'll give it a go tomorrow, and advise.
"vanderghast" wrote:
You are in a better position than me to see if the query is update-able and
if it transfers the id correctly, or not, with your particular settings. For
'simple' case, it definitively does, as in the case I referred, but it is
also easy to get an not-updateable query when it becomes more complex. Note
that even in cases where it works, you have to specify data such that it
does not contradict itself (such as if the join says: on a.id = b.id), by
leaving the child field null in order to the id from the parent to be
carried over, so you may want to test in the user interface (of data view of
the query) first, to see if it works at all, for your case.
Vanderghast, Access MVP
|