Jump to content
Sign in to follow this  
3guk

Filtered Value List

Recommended Posts

Hey Guys,

 

Having a bit of a nightmare trying to get my head around filtered value lists, and I'm guessing it's a relationship issue.

 

I've got two tables:

 

Item - Fields (id, name, linked_category)

Category (cat_id, name, filtername)

 

When creating new items, in the items table, I'd like to be able to have a category dropdown that I can filter (over 300 possible categories).

 

I was hoping to do this by using filtername, whereby the dropdown list of categories that I can choose for an item shows only values where filtername=value.

 

Whats the best way to go about achieving this ?

 

Thanks

 

James

 

 

Share this post


Link to post
Share on other sites

Hi 3guk,

 

To achieve this, you'll need to enable the user to specify the filtername in the item record in order to then present them a list of the corresponding values from the Category table. So you'll need a filtername field in the Item table (you might consider making it a global field, assuming you don't need the value to persist in each record), and then a relationship (using the equijoin "=" relationship operator) from Item to a Table Occurrence of Category that matches the filtername fields in both tables.

 

With this set up, you'll then be able to set the value list to use values from the Category table occurrence (the one related Item::filtername=Category::filtername, choosing the option to display only related values, and specifying the "starting from" context as the Item table.

 

Regards,

Ray

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.