AnsweredAssumed Answered

Hi All! so i have a table with 10 fields that are job titles of each person in the field...

Question asked by MaxwellRobin on Oct 27, 2012
Latest reply on Oct 29, 2012 by MaxwellRobin

Post

     Hi All!

     so i have a table with 10 fields that are job titles of each person

     in the field the user would enter the person's name

     in another table there is a contact sheet which has the title, name, phone #, email.

     what i would like is to have the contact sheet update when the user updates a field in the first table i mentioned.

     if there is no name in the field then the other table should not have a record for that person

     if the empty field get populated then the other table should create a record and populate it with the name the user entered in the first table

     if the field is edited then the cooresponding related field should update

     if the field is populated then the user erases the name it should delete the record it was cooresponding to

     lastly, i would also like the job title to transfer between the tables

     if job title A is populated with MIKE then the related table should populate the name with MIKE and then select from the drop down menu i created with the title A

      

     does this make any sense.

     some help would be greatly appreciated!

      

     thank you!

Outcomes