AnsweredAssumed Answered

Conditional related Data Help

Question asked by AmjadMiandad on Jul 11, 2013
Latest reply on Jul 12, 2013 by AmjadMiandad

Title

Conditional related Data Help

Post

     Hi friends,

      

     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.

      

      

Outcomes