AnsweredAssumed Answered

Filter Value List of the Dropdown

Question asked by petey on Mar 3, 2017
Latest reply on Mar 8, 2017 by philmodjunk

Hello,

 

Goal:

Filter a dropdown value-list by current year.

 

Data:

I have two tables, each of them has a layout:

 

1. School Dates

2. Signups

 

The relationship looks like this:

 

School Dates : PK_School_Dates <-----> Signups : FK_School_Dates

 

On the Signup layout, I have a dropdown to select the school date. That works fine. BUT, when 2018 comes up, that dropdown will double in size and will continue to year after year.

 

What I would like to do is filter the dropdown to only show records for the current year.

 

There's more details.......

 

The value list is setup like this:

 

- Use values from field: School Dates : PK_School_Dates
- Also use values from Second field

 

The second field is located in School Dates, and has the Date, Track, and Type combined. This is so the dropdown shows: 3/17/2017, Laguna Seca, 2-Day Camp

 

If it's worth mentioning, the "Track" field on School Dates is a related filed to a table called Tracks.

 

The dropdown works great, but I'll need to filter it.

 

What I don't want is a solution that forces the user to click more fields than necessary. Something like this:


Dropdown: "Select Year"

(User selects 2017)

Dropdown: "Select Schol Date"

(User selects 3/17/2017, Laguna Seca, 2-Day Camp)

 

Any ideas who to go about this?

 

 

Would you create a calculation field in School Dates, have it merge Date, Track, Type, but filter out by "Year ( Get ( CurrentDate))," and use that for the dropdown values? Somehow it would have to pass the ID along, yeah?? Just a wild guess, haha.

 

Thanks!

Outcomes