many-to-many ?



      * 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

-- 
Fede
________________________________________________________________________
       mune (at) fsfe.org            Ing. Federico Munerotto
   home    http://www.mune-web.eu
Public key http://www.mune-web.eu/personal/misc/pk/pk.html
Signoraggio     http://www.mune-web.eu/personal/misc/signoraggio/
________________________________________________________________________
      posta firmata digitalmente      |      mail digitally signed
______________________________________|_________________________________
A banker is a fellow who lends you his umbrella when the sun is shining
and wants it back the minute it begins to rain.
                -- Mark Twain

Attachment: signature.asc
Description: This is a digitally signed message part



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]