Can you look at the relationships on my table and make any possible suggestions for my requirements please? Not touched access in a while and im unsure of what im doing wrong here.
Its a database on meetings within the workplace and is needed to keep track of actions and employees who the actions are assigned to. I need the database to list all the actions from each meeting and also all actions assigned to each employee.
Currently I am unable to get all actions for each employee from all of the meetings they have attended under their name, it duplicates the name in the person table when entered on a form i created. Would this be due to the relationships between the tables? How would I go about rectifing this?
I want the table "person" to hold a unique list of employees only however i would like to be able to search by that person and bring up all the available actions from all the meetings they have attended, when i do this currently it duplicates the name each time, is this to do with how i have my replationships setup? How would i make this into a 1:1 to test your suggestion below? If this isnt clear please let me know.