Hello. I have a form to add some details for Mr.X (Mr_ID). The corresponding tables are Details_Table (Mr.X's data), Date_Table (visits of Mr. X to my office) and Visit_Details_Table (what happened during the Visit). The tables are connected and working properly.
How can I create a combo box in a form which will contain the values from the Test_Date field, but ONLY the ones connected to the specified Mr_ID, so I can add details to a subform (Visit_Details_Table) and connect them to the Test_date?