Newbies Jason Stratford Posted September 20, 2007 Newbies Share Posted September 20, 2007 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 Link to comment Share on other sites More sharing options...
Søren Dyhr Posted September 20, 2007 Share Posted September 20, 2007 Perhaps you would need this instead? http://www.nightwing.com.au/FileMaker/demos7/demo705.html --sd Link to comment Share on other sites More sharing options...
Anuviel Posted September 21, 2007 Share Posted September 21, 2007 Maybe make id3 and do a calc of id1 & id2? Link to comment Share on other sites More sharing options...
Søren Dyhr Posted September 21, 2007 Share Posted September 21, 2007 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6189 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now