sql - Access combo box to return value from another table -

sql - Access combo box to return value from another table -

i have table called initial_eval has field called partno.

what match partno value in field called 'partno' table called 'update'. what homecoming value in 'consumption' field of 'update' 'partno' values match.

i'm ok sql , bring together stuff, can't crack one

please help.

select u.consumption update u u.partno in (select partno initial_eval)

this assumes there no status while fetching initial_eval

select u.consumption update u u.partno = (select partno initial_eval **some condition**)

in case need frame inner query in such way returns 1 row automatically map consumption table row.

sql