http://i630.photobucket.com/albums/u...ationships.jpg

Picture of relationships ^^^

I have manged to get a little bit of work done today. I've come to the point
were I have to create the relationships between the tables. I'm hoping my
tables are okay so it will just be a case of choosing the right relationships.


I'm not totally sure what I'm doing the right thing here though. I've read
my book a couple of tmes but it isn't totally clear, to me, what I should do.
I don't know what join type to use as there are 3 choices.

1 Only include rows where the joined fields from both tables are equal.

2. Include ALL records from 'tblMatters' and only those records from
'tblAppearance' where the joined fields are equal.

3 Include ALL records from 'tblAppearance' and only those records from
'tblMatters' where the joined fields are equal.

So, going from the picture from above. How to I relate the tblMatters to
tblResults, tblAppearance, tblAtPolice, tblAtCourt and tblClientProfile
(which I've just realised I've missed the field off). What Join type am I to
use?

Just to clear things up. 1 client can have several matters but each matter
will only have one appearance, result and court or police station record.

Thanks in advance,
Andy.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200907/1