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.360 seconds

  I found "cook" two days ago. Played around with it for a day and then within a day got rid of two legacy applications in IBM Lotus Domino Notes and replaced them with "cook". It was really easy. A piece of cake. Actually it was even easier than cooking. Cooking involves more work than developing with "cook". What can I say about "cook"? Great application great price for what it delivers great forum with a lot of information and fast responses active and friendly community fast forward moving development cycle So what should I say "Monsieur Le Cook"? Keep the good work going it will lead to success. Having become a paying member in the words of Edith Piaf may I say ..... non rien de rien ... je ne regrette rien. Vive La France.
FK (JED)
         

Get Started