Gina Whipp wrote:
Andy,

1. Do not worry about the Join Type. Simply check...

Thanks once again for your reply.

I was doing what you said but I kept getting an error message. What I didn't
realise, until I read a few articles, was the Foreign Key needed to be a long
number. In my case it wasn't so I was getting repeated error messages. I've
now sorted that and here is my relationship table.

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

I don't think I've missed anything off this.

Thanks for the links, those articles will be handy material.
Andy.

--
Message posted via http://www.accessmonster.com