I hope I explain my problem right.
Okay here it goes.
4 Tables:
Employee
Project
Element
EmpToProj
Relationships:
Employee To Project: many to many
Employee To Element: many to many
Project To Element: One to many
Forms:
EmpToProj Form: Shows the employees allotted to the projects with the elements
Create Entry Form: Is just the replica of what my main form works like.
Now in the create entry form:
When the employee is selected:
The element Combo box should display whatever element (Here it is terminal) the employee is allotted in the EmpToPRoj table and also whatever he is not allotted should display(I know this is silly. Because of a constraint I am ending up doing this)
The Project Combo box should display whatever projects (Under the element terminal) the employee is allotted in the EmpToProj table and also the Projects under the remaining elements.
Important thing is only the Projects under the element "terminal" (Which is allotted in the EmptoProj table)should display. Not the other projects under the element (Terminal).
In the images I have uploaded.
You can see, UpChunk Shucmer : Doesn't have the projects "Project3" under the project list rest of all the projects are shown, inspite they are not present in the EmpToPRoj Table.
I have uploaded the image of how the element combo box should display and the Project combo box should display.
I hope I explained my problem. Please let me know if any further information is required.