Dataset updating.

[Test]

Using Access 2002 / .Net.

I need to update a database through dataadapter.update(dataset).

The problem is one of the tables had two foreign keys , linking to
autonumbers in its parents tables.

So everytime I try to update...i get the error 'Cannot find a record
relating to 'Table' etc'.

Any Ideas? This has me really confused.

 

[William Ryan eMVP]

Check out Bill Vaughn's Article on "Managing an @@IDentity Crisis" at
www.betav.com -> Articles -> MSDN Magazine. The article targets SQL Server
but the prinicple will be identical.

HTH<

Bill