Response from "Jack Vamvas" <DEL_TO_REPLY@del.com>:

> You are right with the first part : Table 1 = Fruits then create a
> second table e.g FruitRelationships , this would have at least 2
> columns : Fruit_id1 , Fruit_id2
> you could then add as many relationshipts as you require. So if
> you need to change the spelling of the fruit , you change it in
> the Fruits table , if you
> need to change the relationships , you change in
> FruitRelationships

That makes a lot of sense too, thanks Mr. Vamvas.

Just to be sure I totally undersand, Fruit_id1 would probably be the
actual Fruit_id1 from the Fruits table, where Fruit_id2 would be the
primary auto incremented key in the FruitRelationships table, as in:

table: Fruits
Fruit_id1: 1
Fruit_name: grapes

table: FruitRelationships
Fruit_id1: 1
Fruit_id2: 1

....is that what you meant? I hope so because it makes sense to me.
Hehe.

--
-Lost
Remove the extra words to reply by e-mail. Don't e-mail me. I am
kidding. No I am not.