I doubt 1 junction table is appropriate but don't know enough about your business model to advise. You need to gain better understanding of relational database concepts. Identify the entities and relationships of your data and design db to fit.
VIP
Windows XP 
Access 2010 32bit
I doubt 1 junction table is appropriate but don't know enough about your business model to advise. You need to gain better understanding of relational database concepts. Identify the entities and relationships of your data and design db to fit.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows Vista Access 2010 32bit
Thank you very much for your help
Staff can work in multiple projects
Projects can have multiple staff
Clients can have multiple projects
Projects can have multiple clients
I need payroll information that includes staff and projects
I need training information that needs staff and projects
I need banked hours information that include staff and projects
I need cost estimate information for all projects
I need contract information for all projects
I need expenditure information for all projects
VIP
Windows XP Access 2010 32bit
Sounds like a complicated database. Not going to design for you. Lots of tutorials about database design. Identify entities and relationships and build ERD and post for analysis.
Review
http://forums.aspfree.com/microsoft-...es-208217.html
http://www.developerbarn.com/communi...-database.435/
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows Vista Access 2010 32bit
Ok will try. Thanks
Posting Permissions
Reply With Quote