Welcome, Guest
Username: Password: Remember me

TOPIC: [SOLVED] Foreign key/combo box with grouped list

[SOLVED] Foreign key/combo box with grouped list 16 Sep 2012 18:49 #3690

  • Ferm
  • Ferm's Avatar
  • Offline
  • Junior Member
  • Posts: 39
  • Thank you received: 6
  • Karma: 2
Hi,

I am using a nested foreign key strucutre -like the one in your demos- so I have bookings and each booking have an individual assigned to it and each individual is located in a county. So there are three tables: bookings, individuals, counties. The I add a combo box to filter the list by individual, I get the following:

Without ajax: The drop-down is correct, but the text for the individuals is invisible. I can see the counties, and the number or rows for individuals is correct, but the names of the individuals is missing. The selection works, so if I pick an individual (whose name I can't see) the result is correct. It seems that this is not an issue without nesting, i.e. if I only have a foreign key pointint to a talbe with doesn't in its turn have a foreign key I don't get this.

With ajax: With Ajax I have to click twice which is not as elegant as a single drop-down with sub-headings. So I get a drop-down with counties and them when I have selected the county, I get a second drop-down with individuals. Again, in this second drop-down I can't see the names of the individuals. The rows are there, but I don't see the text. Also, it is not possible to reset the selection in ajax without clicking the clear button.

You can have a look at "manage bookings admin" in the component "bookings ver 2".

Grateful for any help!
The administrator has disabled public write access.

Re: Foreign key/combo box with grouped list 17 Sep 2012 08:37 #3701

  • admin
  • admin's Avatar
  • Online
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
Means that your fk are broken. Try to consolidate your database.

Another problem is possible if you've made a lot of changes in the builder.
Try to reset the grouping (Ajax or not), and then recreate them.
Coding is now a piece of cake
The administrator has disabled public write access.
Time to create page: 0.092 seconds

Get Started