T
TOILETS ARE US
I am trying to extract data from my data base. I have created a procedures
data base. Individual procedures can belong to many crews, also belong to
many crew members. I have 4 tables set up. 1st crew detail-contains procedure
ID and crew. 2nd table crew member-contains crew member crew crew verifier.
3rd table crew member detail - contains crew member procedure ID date trained
ect. 4th table procedure number- contains procedure ID auto number procedure
number and procedure name. I need to create a report that shows what
procedures belong to the crew(that is easy). The problem I have is pulling
the procedures per crew member for a certian crew. (crew members can be
trained on procedures for multiple crews) I have trie inner and outer joins
nothing is working HELP!!!!
THANKS
data base. Individual procedures can belong to many crews, also belong to
many crew members. I have 4 tables set up. 1st crew detail-contains procedure
ID and crew. 2nd table crew member-contains crew member crew crew verifier.
3rd table crew member detail - contains crew member procedure ID date trained
ect. 4th table procedure number- contains procedure ID auto number procedure
number and procedure name. I need to create a report that shows what
procedures belong to the crew(that is easy). The problem I have is pulling
the procedures per crew member for a certian crew. (crew members can be
trained on procedures for multiple crews) I have trie inner and outer joins
nothing is working HELP!!!!
THANKS