I have three tables and one Form
Table_1
Table_2
Table_3
Form_1
Table_1 is linked to Table_3 in One-to-Many Relationship and Table_2 is linked to Table_3 in One-to-Many Relationship
Form_1 has a few Tex Boxes that enters data into Table_2
Form_1 also has a Subform that enters data in Table_3 and it contains two Combo Boxes, the first Combo Box picks values from the ID field of Table_2 and the second Combo Box picks values from the ID field of Table_1.
When the user clicks on the second Combo Box in the Subform, it displays all the values, even the previously selected values, I need this Combo Box to display only values that are not already entered in Table_3 and hide the values that are already entered.
Thank you for your help