Hello learned people!
I'm new with Ms Access (2007)
This is my first thread and i hope somebody can help me!
I have 2 tables: Recruiter and Candidate. There is a relation between them. 1 Recruiter can have more Candidates.
Table fields:
Candidate: C_Nr(key), R_Nr, C_Name etc.
Recruiter: R_Nr(Key), R_Name etc.
Now i have a form and i want to select a Recruitername with a combobox and find the first Candidate from this recruiter.
Is it possible to make this in the After_Update action?
Or did i made a mistake in my table structure?
Please help me!
Thank you!
I'm new with Ms Access (2007)
This is my first thread and i hope somebody can help me!
I have 2 tables: Recruiter and Candidate. There is a relation between them. 1 Recruiter can have more Candidates.
Table fields:
Candidate: C_Nr(key), R_Nr, C_Name etc.
Recruiter: R_Nr(Key), R_Name etc.
Now i have a form and i want to select a Recruitername with a combobox and find the first Candidate from this recruiter.
Is it possible to make this in the After_Update action?
Or did i made a mistake in my table structure?
Please help me!
Thank you!