Re: Access as a RDBMS--why the multiple relationships?

Evan Keel schreef:
> raylopez99 wrote:

>> ...TWO, not just one, relationship arrows between
>> tables.  But I think (and I just want confirmation of this) that one
>> of these two relationship arrows is bogus, and more like a query than
>> a true relationship.

> My 2 cents. In my experience, when you have more than one relationship among
> tables you are really describing roles. For example: Professor tutors
> Student and Professor advises Student, where tutor and advisor are roles.

2 cents more. You just do not run into this non-problem when you think of roles.
You are describing roles a lot of the time, period. That is, not only when you have more than one relationship.

http://orm.net

--
What you see depends on where you stand.