Hi,
I have 3 tables A, B, C, having the cardanility as A(1:N)B(N:N)C.
Is this a Fan Trap ? If so, what is the best possible solution ?
Ria
ria332 (BOB member since 2007-10-14)
Hi,
I have 3 tables A, B, C, having the cardanility as A(1:N)B(N:N)C.
Is this a Fan Trap ? If so, what is the best possible solution ?
Ria
ria332 (BOB member since 2007-10-14)
Yes, that’s the classic definition of a fan trap. You could try searching for past discussions, but start with this entry from our Designer FAQ = “Frequently Asked Questions”.
Please remember to check FAQs and to do searches before you post a new topic.
Anita Craig (BOB member since 2002-06-17)
Thanks a lot Anita.
ria332 (BOB member since 2007-10-14)
Are you saying you have a many to many relationship between B and C?
That’s not a fan trap, that’s just… wrong.
Dave Rathbun (BOB member since 2002-06-06)