Same Key with many relationships?

[charly]

Hi

I've heard that I shouldn't create many relationships using the same key (client number)... I'm building a database at the moment which would become rather annoying if I had to use several different serial numbers for each relationship - so was I told something silly?

Thanks in advance

Charly

[BobWeaver]

I can't think of any reason why you shouldn't use the same key field in several relationships. I do it all the time.

[charly]

Thank you - I've been wondering how to get around that!

[DanBrill]

That would be crazy. I have hundreds of relationships built this way and they have never given me a problem. I come by my problems the old fashioned way: I create them. I wouldn't worry a bit.

Dan