Entity Relationship question - Database Discussions
This is a discussion on Entity Relationship question - Database Discussions ; Hi guys, Was looking for some help in figuring out the best way to relate some tables. I am creating a database in Access that will manage project information. So a project has one client(or owner) company. There might be ...
![]() |
| | LinkBack | Thread Tools | Display Modes |
|
#1
| |||
| |||
| Was looking for some help in figuring out the best way to relate some tables. I am creating a database in Access that will manage project information. So a project has one client(or owner) company. There might be many contacts (individuals) in the client company but only one of them is the prime contact for that project. Different contacts can be Prime contacts or not for different projects. I have created: 1:M between Project and Client. 1:M between Client and Client contact M:M between Project and Client contact Now my question is: how do I relate Prime client contact in there? I know that prime client contact is directly related to a project and client contact. Any help will be greatly appreciated. thanks ahead. Q |
![]() |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
| |
All times are GMT -4. The time now is 02:29 AM.




Linear Mode