Sure, just add a new record to each table and autonumber will increment
in both.
I am afraid though that you are talking about *the same* autonumber :-(
If you run an append query, it should set the value of an Autonumber field.
It's an extremely unusual thing to need to do, though. Perhaps if you
explained what you're trying to do, someone could offer a better suggestion.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
