Jump to content
Sign in to follow this  
Daryl

Value list drill down to data

Recommended Posts

I have two tables, table A with a one to many relationship to table B. Table B has 3 fields per record that describe the item. One field is "Category", the second field is "SubCategory1" and the third field is "SubCategory2". In a layout for Table A I want to build a series of 3 value lists that drill down to the item in table B and report in a portal. The top level value list would populate with the Category data, the second level value list would then populate with filtered data based on the category data. The third value list would populate with filtered data based on the subcategory1 value and thereby showing me the records in a portal that meet all these criteria.

I have tried this many different ways and continue to run into a dead end. I cannot be the only one trying to do this between two simple related tables.

Share this post


Link to post
Share on other sites

Without knowing the extent to the data and assuming you are limited to 3 category levels... you could just have 3 tables and link them 1 to many -- 1 to many -- 1 to many....

That is the easiest....

If you are looking to dynamically expand the category levels... well you'll have to be a little more elegant.

Share this post


Link to post
Share on other sites

Thanks for the reply Jamie. I don't want a third table in this scenario. I just need the value lists to drill the data down.

Daryl

Share this post


Link to post
Share on other sites

Hello Jamie,

That is exactly what I'm looking for. I will have to study how your relationships work as well as how your value lists are set up but the result is what I'm looking for. Thanks so much for the help.

Daryl

Share this post


Link to post
Share on other sites

So... I got to thinking about this thing, this morning. I thought, wouldn't it be cool to be able to use a repeating fields instead? That way you would have far fewer fields to setup...

So, I made changes to the example file to include just such a senario.

Have a look... Make sure to install ZippScript before you open the DB, if you don't already have it.

:

categories.zip

Share this post


Link to post
Share on other sites

There is a problem with the examples as presented... They don't work properly in find mode... B)

Sorry... I am looking into it.

Share this post


Link to post
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
Reply to this topic...

×   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.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.