N-M Relation Question

[amcgilly]

Let's say I'm creating a time billing system, and I've got the following tables:

projects
consultants
assignments (contains foreign keys projectsid and consultantsid, used to establish a many-to-many relationship between projects and consultants)

Now, if I have a Projects window and I want to display a single project and a list of consultants assigned to that project.

To populate that list of consultants, I need to draw on the many-to-many relationship. Can I do that using Servoy's relation object or do I need to roll my own SQL query?

[Jan Aleman]

Here's an article that describes how to do that.

http://www.servoymagazine.com/home/2004 ... _rela.html