relationships

[ilaria71]

I want to link a master table with a child table where only some of the records in the master table have one (and only one) corresponding record in the child table. The other records in the master don't have any records in the child table. What kind of relationship should I use for the link?
Thanks a lot!!

 

[traingamer]

Use one to one.


Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[PHV]

I'd say 0:1

 

[traingamer]

As described, it is a 0:1 relationship. But can you define that in Access?

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill