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.
