Relationships

[Andy]

HI,

Im kinda new to all this, have a question.

Can a table have more than one relationship on one field,
ie

I have a main table called tblmain, with linked relation
ship to two other tables one called tblattach and one
called tblvisits both these tables have merchant as the
link to the main table. Is this allowed?

tblmain----
Merchant(pk)
Contact name
Address
etc

tblattach---
attachid(pk)
merchant
summary
etc

tblvisit---
visitid(pk)
merchant
summary
etc

 

[Rebecca Riordan]

Yes, provided your relationships are one-to-many, with tblMain being on the
one-side of both relationships.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

 

[Andy]

Thanx for that Rebecca

-----Original Message-----
Yes, provided your relationships are one-to-many, with tblMain being on the
one-side of both relationships.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...




.