jamesdpmullan
Registered User.
- Local time
- Today, 16:17
- Joined
- Oct 21, 2013
- Messages
- 24
Hi
I have created an advanced database which a site of 70 odd people use however im trying to create something which i believe should be relatively easy but appears i may be trying to hard to make it work!
I have attached a department matrix as an example of what it currently looks like through a spreadsheet and i am trying to replicate this but in an access database.
Each department has and area attached of which certain staff members need to be selected for their relevant departments - at this point each of the areas within the department need a matrix key selecting.
I currently have tried creating carious tables and linking but just cannot get it working. The tables i believe should be TblEmployee (Name), TblDepartment (Name, Department), TblMatrix (Name, Department, Area, Matrix Key)
Any help appreciated!
I have created an advanced database which a site of 70 odd people use however im trying to create something which i believe should be relatively easy but appears i may be trying to hard to make it work!
I have attached a department matrix as an example of what it currently looks like through a spreadsheet and i am trying to replicate this but in an access database.
Each department has and area attached of which certain staff members need to be selected for their relevant departments - at this point each of the areas within the department need a matrix key selecting.
I currently have tried creating carious tables and linking but just cannot get it working. The tables i believe should be TblEmployee (Name), TblDepartment (Name, Department), TblMatrix (Name, Department, Area, Matrix Key)
Any help appreciated!
