I am very new to access so please forgive me if my question is basic.
I am trying to create a database for a visual basic 'shift storage' project. I want to create a table that stores details of employees, and for each employee have a 'sub table' that stores various bits of information about their daily shifts. So far I have come across sub data sheets but this seems to associate the same table of data with all employee entries.
Is there a way to create a table template that I can re-use for every employee - i.e. only stores the parent employees shift details? So basically I want sub datasheets that have the same structure as each other but only contain values that are relevent only to the parent entry (not table).
Can someone point me in the way of a topic or tutorial that may help me as I don't know what I am looking for.