The short way of saying this is "one person can have many dogs". I skimmed back through the book, and the example in 7.2.6 is closest, but it isn't adding a dog, just listing a dog already known, so there is just one owner to find (it's given as a link). <http://www.web2py.com/books/default/chapter/29/07/forms-and-validators#Links-to-referencing-records>
But perhaps the recent discussion of cascading dropdowns has some clues; there's a Slice for that: <http://www.web2pyslices.com/slice/show/1724/cascading-dropdowns-simplified> /dps On Thursday, November 14, 2013 9:55:56 PM UTC-8, Sarbjit wrote: > > Thanks stifan for reply, > > As stated earlier, this is an sample example. For the second problem, in > my actual problem I am having different records present for same owner > (Consider same NAME for person field). Now when I say, my PERSON table can > have multiple records with the same name, it means the person is same but > have records associated with him. > > Since in my Person table, my person NAME field is referring to same > person, it doesn't makes sense to show all the records from PERSON NAME > field in DOG table as they are anyway referencing to same person. So I just > want to show Person name once in case it finds duplicate records in PERSON. > (Duplicate NAME but will have different other records) > > -Sarbjit > > On Friday, November 15, 2013 11:17:53 AM UTC+5:30, 黄祥 wrote: >> >> *Problem1 :- Referenced field id is seen in grid, I want to have the >>> referenced field 'name' value* >>> >>> Please insert few records using appadmin/grid and view the records, it >>> will show the NAME field (DOG table) having the value as ID for the PERSON >>> table. How can I view the name of the person name here and not the ID from >>> PERSON table. >>> >> >> please do with record representation. >> e.g. >> db.define_table('person', >> Field('name'), >> Field('country'), >> *format = '%(name)s'* ) >> >> ref: >> >> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Record-representation >> >> >>> >>> *Problem2: In my case, Person field can have duplicate names, i.e. >>> multiple records with the same name can be present. But I want that in DOG >>> table, unique name to be seen in drop down list (seen in edit/add record).* >>> >> >> hm, not sure in here, i think, it can be boomerang to you. because you >> want person field name can have duplicate name, but you want to eliminate >> it (make it unique) in dog table owner field. >> e.g. >> person : >> id : 1 >> name : kiba >> country : sunagakure >> >> id : 2 >> name : kiba >> country : konohagakure >> >> now, when i select the owner field in dog table, which kiba i refer to? >> it will make the user confuse. you want to distinct it, then >> which kiba will be eliminate then? >> if you want duplicate name, i think you can add a field for describe it. >> e.g. last_name, nick_name, etc. then if the name field can have duplicate, >> that fine, but not the combination name and the other field (last_name, >> nick_name, etc). >> or for your current condition i think you can have the combination for >> name and country field as record representation. >> e.g. >> db.define_table('person', >> Field('name'), >> Field('country'), >> *format = '%(name)s **%(country)s**'* ) >> >> best regards, >> stifan >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
