Query to retrieve record

[Zoom1234]

Hello,
I am really stucked.

I have following table structurs

Company
member_id number PK
name text
DOB text

project
proj_id number PK
proj_name text
startdate Date/Time
enddate Date/Time

client
client_id number PK
client_name text

[bprojVSclient[/b]
proj_id number
client_id number

projectdetails
proj_id number
member_id number
role number
location number

role is either 1(ie PL) or 2(TM)
location is either 1(office) or 2(Client side)
What i want to retrive is project specific info in the form of
proj_name
startdate
enddate
PL from client side, DOB
All TMs from client side and their DOBs
PL from office side, DOB
All TMs from office side and their DOBs


I am clueless to wht shd i go abt this.

Pls help

 

[willir]

Zoom

What specifically is your issue? Are you trying to draw erlationships from your data?

You are obviously trying to design a system for tracking proejcts. Clients and Projects have a many-to-many relationship.

But what is a role, what is a DOB?

 

[Zoom1234]

Hi willir ,

Basically i want a project specific report on monthly basis having the details mentioned above ie project name,startdate,enddate,project leader and their DOB (date of birth) and team members and their DOB.
so i have designed tables as mentioned in my previous thread.

ANyway i think i have got a solution to this issue. i will have to check that .

Thanks for the extended help

 

[lespaul]

I think you need to read 'The Fundamentals of Relational Database Design'

People have dates of birth, companies do not. People work for companies.

tblCompanies
CompanyID
CompanyName
CompanyAddress

tblPeople
PeopleID
pplFirstName
pplLastName
pplAddress
DOB
CompanyID (ONLY IF A PERSON CAN ONLY BE ASSOCIATED W/ ONE COMPANY - if a person can be associated w/ many companies, you would need a different table set up for that situation)


Leslie