I have been away from Access for so long, in the dark recesses of MySql that I've forgotten how to use it!! Short of exporting the data and then reimporting, any Access guru like to help out?

Basically, it's a conversion thing....

I have two tables, one like thus:

ID SubID IDdefininition

and another pretty much the same

ID SubID GenericIDdefinition

the first table actually has loads more fields, but they are irrelevent to this problem.

I would like to update the IDdefinition in the first table to the GenericID, where the ID AND SubID are the same. I'm buggered if I can remember how to do it.....any help pls???

(I'll never diss .asp again * )

* (today)