It sound like you need to create three tables instead, one for cities, one for groups and one for city-group combos.
On Nov 17, 6:52 am, Renato Ramiro <[email protected]> wrote: > In my application, I have two tables: City and Hospital. > > In the table City, there are two fields: name and group. > And the table Hospital, there are name, number of beds, number of medics, > and city (foreign key). > > Through the wizard, I did this (below): > > Field('f_city', type='reference t_city', > label=T('City')), > > And manually I added this (below) > > Field('f_group', type='reference t_city', > label=T('Group')), > > At the moment of creating a Hospital, I have two combobox. One labeled > city, the other labeled group, but the second won't show the group. It > shows the city instead. > > Is there some way to show the group? > -- > Renato Ramiro
