Jump to content

Filtered Value List


This topic is 2864 days old. Please don't post here. Open a new topic instead.

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 ?







Link to comment
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.




Link to comment
Share on other sites

This topic is 2864 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

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