I'm developping a database application and i'm having problems selecting values.
I have two tables
TBLJOBS with fields JOB_ID, CLIENT_ID
and TBLCLIENTS with fields CLIENT_ID, NAME, ADDRESS,...
There is a one to many relation between TBLCLIENTS.CLIENT_ID and TBLJOBS.CLIENT_ID
In my form i want a combobox selecting JOB-ID.
After the JOB_ID is selected i want my client fields updated depending on CLIENT_ID field.
Can anyone help me out here?