Good day all,
I got a quick question..
I got 2 tables
Departments:
ID
Department
Functions:
ID
Function
Department_ID
They are linked with an one to many relation.
Now when i'm making my form i want to have 2 combo boxes, 1 listing the results found in Departments.Department and another listing the results of Functions.Function where the Functions.Department_ID is equal to Departments.ID.
When i put this in an sql query it doesnt work, at best it asks me to put in the Departments.ID manualy tho i want the functions combobox updated when i pick something from Department.
Thanks in advance
I got a quick question..
I got 2 tables
Departments:
ID
Department
Functions:
ID
Function
Department_ID
They are linked with an one to many relation.
Now when i'm making my form i want to have 2 combo boxes, 1 listing the results found in Departments.Department and another listing the results of Functions.Function where the Functions.Department_ID is equal to Departments.ID.
When i put this in an sql query it doesnt work, at best it asks me to put in the Departments.ID manualy tho i want the functions combobox updated when i pick something from Department.
Thanks in advance