Hi,


""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
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

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