Andy,

All looks great except you forgot Cascading Updates on tblMatters -
tblResults and you can remove rMatterID from tblResults as it will be linked
by rUFNID. Fix those and all looks perfect.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"andycambo via AccessMonster.com" u53471@uwe wrote in message
news:99a89102f5aa8@uwe...
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