Subject Re: [IBO] Many to many rel.
Author Martijn Tonies

""og"" <og > wrote in message news:00b901c1b3e9$13b3d8f0$8bf2a8c0@VS5510...
> Hi, I'm wondering if there is someone who can guide my in making a many to
> many relationship work.
> I have three table's:
> Table A: aid integer, bName string, bTel string
> Table B: bid integer, bName string, bTel string
> and then the connecting table
> Table C: cid integer, aid integer, bid integer
> Do I need cid in table C?

If you can identify records in C by AID and BID, I would leave out CID - it
has no use the. But this is only possible if the combination AID and BID is
unique - but I guess it is.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."