number_one
May 18th, 2001, 05:34 AM
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.
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.