I think you are looking for db.groups.id_group_type.requires=IS_IN_DB(db,'group_type.id','%(type) s')
this will make a dropbox with the group_type.id represented by their type(s). Massimo On Dec 20, 12:54 am, Jeremy Mikkelsen <[email protected]> wrote: > Great little framework you guys have going here. I am new to python > (thanks GAE) and new to web2py. It actually reminds me of a php > framework that I liked and used called qcodo. It takes a similar MVC > view toward things (despite being PHP) Web2py is really much simpler & > elegant, however one of the things about the qcodo ORM generated CRUD > interface was that it incorporated the FK relationships. In the admin > interface generated from the ORM it would create a listbox for each > field that was a FK, and that list box would be populated by the > available values in the related table. You then had to specify which > part of the data you wanted to see in the list box. > > You can see what I am talking about in about four minutes... pull up > the screencast located > athttp://www.qcodo.com/demos/beta_2/demo_d_form_drafts/demo_d_form_draf... > and skip to 5:50 and watch until 10:00ish. > > Here is my little test that I was working with, for the given model > <code> > db.define_table("group_type", > SQLField("type", "string", notnull=True, default=None)) > > db.define_table("groups", > SQLField("title", "string", notnull=True, default=None), > SQLField("desc", "string", notnull=True, default=None), > SQLField("id_group_type", db.group_type)) > </code> > > I was envisioning that while "editing" [http://localhost:8000/XZY/ > appadmin/insert/db/groups] the groups table from the admin interface > to see the list of available type id's as a drop down list along side > the other two text boxes. (Or even better the type string's which > would need to be based on a standard naming convention or > configuration.) > > After all that... here is ny question: is something like that > available in web2py that I missed while watching your screencasts and > reading the online docs? (I admit, I haven't jumped for the PDF or > book yet). --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
