All I seem to be going around in circles with my Db design. Thanks to all have helped with questions thus far.
I need to 're design' my tables, I think, to best utilise the Db.
Currently the Db is a data capture tool for staff performance reviews. the initial set up was based on information that was imported from a spreadsheet [tblStatementDetails] and a form was built from this data. Now I need to 'improve' the Db so that the main table [tblStatementDetails] holds all employees data. this information will come from a table [EmployeeData].
I am sure I know the answer but logic has escaped me on this one....
The main form [tblMainPage]currently 'loads' data from [tblStatementDetails] through a search of ID numbers, BUT, as this does not 'link' to the [EmployeeData] not all staff are within the main data table.How do I get the [tblStatementDetails] to 'update' with the data from [EmployeeData] as most recent data is imported monthly.
[EmployeeData] is from in import where as the Perfomance data is entered / updated against each employee via the form
I guess to really simplify my questions:
I need all employee related data to read from [EmployeeData] table and the related Performance Management information to read from [tblStatementDetails] BUT need to capture all employee data with related Performance data in [tblStatementDetails].
Maybe I am making more out of this than needs...but I seem to be travelling in circles on how to get this