Many to many relationship

[Akii]

Is many to many relationship is possible in IDMs? Please can anybody explain this

[dick scherrer]

Hello and welcome to the forum,

Well, yes. . . So far, i've not seen any database system that prevents many-many relationships.

Are you familiar with the many-many concept?

It is not clear what you want explained. If you show an example of what you are working with/looking for, someone may be able to post a more useful reply.

[Akii]

Thanks, In IDMS Set represent one to many relationship in the same way can set support many to many relationship, this question was asked to me in one of the interview.

[BradfordDobbins]

In IDMS... Junction records are used to create many to many relationships.

For instance a many to many beteween recs TEACHER and STUDENT may be
created by using a junction record named TCHSTU

Each TEACHER rec would be connected to many TCHSTU recs ( a 1 to many )

Each STUDENT rec would be connected to many TCHSTU recs ( a 1 to many)

combined this construct creates a many to many

TEACHER------->TCHSTU<---------STUDENT

[dick scherrer]

Hello and welcome to the forum,

Good to have a new IDMSer with us