dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

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 ...



Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 07-23-2008, 12:08 PM
Database Newbie
 
Join Date: Jul 2008
Posts: 1
Heminem80 is on a distinguished road
Default Entity Relationship question

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 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
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 02:29 AM.