What is the best way to handle the following situation?

I have one main table with an Autonumber ID field, and multiple tables that need this ID from the main table. I need to work in a disconnected environment, and ADO disconnected recordsets are almost perfect except for one thing.

How do I allow entries of records into both the main table and the secondary tables when disconnected from the database? There is not yet a generated Autonumber field to insert into the secondary tables, and I see no way to make it generate these values on the fly when calling the UpdateBatch method. Any help would be greatly appreciated. Thanks.