linking tables

[stuart R]

Hi,

I am designing a database and a part of it consists of one table linked to three others by one to many links. I was wondering whether there would be any advantage in forming a one to many link between two of the child tables forming a triangle - this would be possible just using existing keys.

Thanks

Stuart R

 

[Jack Cowley]

I'm sorry but I don't understand your question. You should have your Primary key and then the Foreign keys in the related table(s) so I don't know what you want to do beyond that.

Jack

 

[Pat Hartman]

Relationships are not arbitrary and just because the keys seem to work for one doesn't mean that you should define it. What are the business rules? If you can't decide for yourself, post your tables and we'll help.

 

[stuart R]

Hi,

Thank you Jack and Pat.

I'm sorry that my question wasn't very clear. I have defined the relationships and am now quite happy with the result. I took on board what you said about not defining relationships just because the keys are there and will not be linking two of the child tables together. I cannot seem to send or copy the relationship window or I would send it for your approval.

I'm am just starting to work my way through Beginning Access 2000 VBA so will probably have more questions before long!

Thanks again

Stuart Ross

 

[Jack Cowley]

You are welcome and good luck with your project...

Jack

 

[Pat Hartman]

If you have something like SnagIt, copy the relationships window and save it as a .jpg and attach that. Otherwise, you can use print screen and copy the image into paint where you can also save it as .jpg.

 

[stuart R]

Thanks

Thank you Pat - I couldn't copy the print screen into paint so I'm going to look into getting hold of SnagIt software.

Cheers,

Stuart

 

[Pat Hartman]

You can download it from www.techsmith.com. I believe they have a full function limited use demo so you can try before you buy. I find the program invaluable for creating documentation. It is quite easy to use and very flexible in what you can capture and what you can do with the captured image.

 

[stuart R]

Thanks again Pat. I'll check out that link.

Stuart