Table Relations Problems!!

tflett

Registered User.
Local time
Today, 17:36
Joined
Aug 3, 2007
Messages
40
I have a DB and for some reason queries aren't working properly. My guess is the table relationships I made. If anyone else has an idea on changing my relationships so that all forms and queries will work to thier full potential please give my DB a look.

Any Help will be greatly Appreciated
View attachment PPT-Trainee DB.zip
 
You gave no detail on what is not working. You supplied no detail at all. "My queries don't work!" is not answerable.

What did you try? What were the results? What are you expecting as results?

The way you've phrased it, it's like me saying, "I went to start my car today and it didn't start! Help!"

You can't get an answer without investigating it yourself. And if you're stuck afterward, then tell us the steps you went through and the messages you got.
 
I agree with Moniker. However there is an obvious flaw in your design. Primary training and secondary training data should be held in a single table with a field to show if it is primary or secondary (or tertiary or quadrenary, etc).

The instant clue to this flaw is that there are two realtionships between trades and client info via these two tables.
 

Users who are viewing this thread

Back
Top Bottom