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.



-----------

Also the adapter is created in code..not through the gui....so it doesnt
seem to trap its '.rowupdated events'

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
"Test" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
>
>
> -----------
>
> Also the adapter is created in code..not through the gui....so it doesnt
> seem to trap its '.rowupdated events'
>
>
>
>