I have a Project in MS Access in which i have made a 4 Table. The table name is as follow Planning, Quality,Production and Manufacturing, each table contain email address.
Now in Form i have made a Combo box which show the name of the Table(Planning, Quality,Production and Manufacturing).So now i want a another Combo box or any other box which show the Email address of particular sector. For example when i select the Planning in 1st combo box, the second box should show me all the email address of planning sector. And i can select one or more email address from that second box.
Can anyone has Idea how to do this? as i am new and dont have much knowledge of MS Access.
Thanks in Advance.