I have three tables;
I want a query to update the CLass_id field in the TABLE C...
So basically need to run through and link the invt( Table C ) to Table A ( by Invt )
then link to Table B ( by Class )to get the Class_id I need...
Can this be done with an update query ?