Conditional related Data Help
I was trying to sort out my problem,
I have two tables "Employee" and "Info" have made relationship between them through ID field.
Now I have a form for another table "Offices" having 3 fields one is "Manager Name" field which is grabing data from the value list created from "Employee Name" field from Table "Employee" second field on my form Offices is 'email' and 3rd field is 'phone number'
Now how is it possible that if I select "Mr. Jhon" in "Manager Name" (which is grabing data from the value list created from "Employee Name") and rest of the two fields 'email' and 'Phone number' could get/fill related data automatically against Mr. Jhon from "Info" Table.