Hi All
I am just working on a database I need a little help with the logic, I have 3 tables for example
Department
Staff
Resources
I need to assign a resource to either / or a department or staff member is the correct way to do this add 2 foreign keys to the resources and make the foriegn keys non requied.
Or do I need to use some kind of link table.
Liam
I am just working on a database I need a little help with the logic, I have 3 tables for example
Department
Staff
Resources
I need to assign a resource to either / or a department or staff member is the correct way to do this add 2 foreign keys to the resources and make the foriegn keys non requied.
Or do I need to use some kind of link table.
Liam