#24 reflexive n:m relations

[Anonymous]

when you add an n:m relation dbdeisgner creates a new
table but with only one id foreign key... it must to
add two foreigkeys. Isn't it?

sample:

TABLE: table_group
fields: idgroup

ADDING REFLEXIVE N:M RELATION....

TABLE: table_group
field: idgroup

TABLE: table_group_has_table_group
field: idgroup (FK)

--->>>>> correction:

TABLE: table_group
field: idgroup

TABLE: table_group_has_table_group
field: idgroup1 (FK)
field: idgroup2 (FK)

to ident de table_group idgroup