Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

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

  • Ferm
  • Ferm's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 39
  • Thank you received: 6
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!

Please Log in or Create an account to join the conversation.

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

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
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

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.102 seconds
  I still don't believe he can really be human to do all this ! From all of the forums that I've ever participated in this is certainly the one that most encapsulates the feeling of being truly open source where everyone's opinions and contributions can and will shape the development of the service! It's truly awesome! Hope you enjoy cooking and look forward to reading and contributing to any of the editorial work that you proposed too!! Thanks
Gez (audibleid - JED)

Get Started