many to many valuelist

A place for users and developers of the Xataface to discuss and receive support.

many to many valuelist

Postby rolandsnowe » Wed Nov 28, 2007 12:45 pm

i've searched around and saw similar posts, but not a solution for this situation. i have a many to many relationship between projects and people. right now everything is working fine except that when you add an existing person to a project, the select list contains only their last name field, whereas i would like to use 'last, first'.

i found a couple of posts about concatenating in the sql and using a valuelist, however these were for 1-m it seemed. i tried adding the custom valuelist to my m-m table folder and applying the select widget to the 'people' id portion of the relationship in the fields.ini for my 'project to people' table. i also tried putting the valuelist definition in various other places with no success.
rolandsnowe
 
Posts: 4
Joined: Thu Nov 08, 2007 4:13 pm

Postby shannah » Wed Nov 28, 2007 2:23 pm

Hi Roland,

Dataface has no concept of an n to n relationship. Only 1 to n. An n to n relationship is modeled by 2 x 1-to-n relationships. One from each side of the relationship.

So in your case, you would create 2 valuelists. One for each side of the relationship.
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 38 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved