many to many with unique constraint

[Jason Stratford]

Hello

How do you setup a many to many relationship with a unique constraint across the two id's?

eg

Link table contains fields id1 and id2

I need fields id1 and id2 to form a unique composite key.

I can not seem to find a way to do this...

can anyone help?

Thanks

Jason

[Søren Dyhr]

Perhaps you would need this instead?

http://www.nightwing.com.au/FileMaker/demos7/demo705.html

--sd

[Anuviel]

Maybe make id3 and do a calc of id1 & id2?

[Søren Dyhr]

Maybe, but the relation seems to simulate a permutatet plucking, which stricktly speaking isn't what a many2many is about, since it never can be a selection of records related ...when only one matches another two tables away?

--sd