Jump to content
  • 0

Cascading Listbox to Fill in Other Fields


aukirk

Question

Can anyone help me with how I can use the results of a cascading listbox to fill in other fields? For example, lets say we are using a lookup table that contains four columns. The first has the type of food (ie Fruit, Vegatable, etc). After the type of food is selected in the first list box, the second list box provides various versions of that food (ie Apples, Bananas, etc.). Then within that table each of those food items has two other fields with information associated with the product (i.e. one may indicate the price and another a description of the product).

After the cascading listboxes are selected for "Fruit" and "Vegatable", how do I get it to automatically fill in the values for the Price and Description field? I assume this involves Javascript and would really appreciate if anyone could point me in the right direction on this.

Thanks!

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Thanks for the quick reply... I have seen that article and have got the cascading listboxes working as described in that article. The additional step I can't figure out is how to have additional display fields that show information from the other fields in that same record in the lookup database. Such that if the food group and specific food are chosen, I would like additional fields elsewhere on the form to be populated with information.

Link to comment
Share on other sites

  • 0

hi,

as I see, you want one dropdown and 3-4 cascading dropdown. And you have one lookup table that has all the fields needed to construct dropdown and cascading. But, you want the last cascading(suppose description) to be shown in a paragraph form(and not in a single line) as a text area. If this is the case, then I guess you will need Javascript. I am not good with it. You can ask caspio support to help you. But ya.. there will be certain $$

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...