Re: many-to-many ?

[Murray Cumming <murrayc murrayc com>]

Sorry, could you try again to explain what theses tables should show, in
terms of what a normal user would understand?

On Thu, 2007-10-04 at 10:27 +0200, Federico Munerotto wrote:
> * Hi all, I couldn't find an answer to this on the old questions;
>         if there
> is already an answer just point me there.
>
> I have a many-to-many relation:
> |  LINKS  |------ N -----< about >------ M -----|  BRANDS  |
>
> In database is implemented as
> -table_links
> ------ id_r_about
> - table_brands
> ----- name
> ----- id_r_about
> - table_r_about
> ----- id_r_about
> ----- id_links
> ----- id_brand
> ----- desc
> ----- site
>
> or
> |  LINKS  | N----------1 | r_about | 1-----------N |  BRANDS  |
>
> In glom I would like to show a form for the LINKS table with a combo
> with the names of the brands (table_brands.name). In background glom
> while showing the brand's name -taken from the BRANDS table- should
> insert the new id_r_about, while creating a new row in table_r_about
> with the selected brand's id and the link's id currently in edit.
>
> That is what glom SHOULD do, but as I guess this is a feature not yet
> available, so I did a
>
> WORKAROUND.
>
> When showing the form for LINKS a combo is displayed with
> table_r_about.id_r_about and table_r_about.desc: where
> table_r_about.desc is table_brands.name. 
>
> table_r_about has to be properly set.
>
> My question is: 
> is there a method to automatically copy table_brands.name in
> table_r_about.desc in the form for adding a new table_r_about's row? Now
> I'm copying it by hand but it is boring and error prone.
>
> Thanks in advance
>
> _______________________________________________
> glom-devel-list mailing list
> glom-devel-list gnome org
> http://mail.gnome.org/mailman/listinfo/glom-devel-list
-- 
murrayc murrayc com
www.murrayc.com
www.openismus.com