Re: [RDBO] creating related records with a multi-valued primary key

2006-11-09 Thread Jud Dagnall
> There are a few possible ways to go about this. One is the manual > way, where you actually instantiate and them modify the map record > separately, as shown here: ... > Finally, you could forego the many-to-many relationship definition and > instead (or "also") defined it as chain of rel

Re: [RDBO] creating related records with a multi-valued primary key

2006-11-08 Thread John Siracusa
On 11/7/06, Jud Dagnall <[EMAIL PROTECTED]> wrote: > In my application, there is are projects, tags, and profiles (users). > Projects can be tagged by multiple profiles. Each tag has a many-to-many > relationship both projects and profiles. There's a mapping table > (tag_project_profile_map) with a

[RDBO] creating related records with a multi-valued primary key

2006-11-07 Thread Jud Dagnall
In my application, there is are projects, tags, and profiles (users). Projects can be tagged by multiple profiles. Each tag has a many-to-many relationship both projects and profiles. There's a mapping table (tag_project_profile_map) with a 3-column primary key that relates those three tables.