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!