* 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