need help with Conditional Value list

[solarpunk]

Hello,

i am runnin FM 6.0, i am want to use conditional value list base on to list, they are Location and Year, the other field involve id call Program Name. The two DB are Students and Program. Basically, when a user choose the location, year, i want this other List to show all the program name base on that.

example.

if i have Austin, 2006, i want to see all the program name base on those.

i got to work when i choose the city it show me all the program name base on that city, i need to break it down now by the year also.

thank you.

victor

[-Queue-]

Create a calculation field in both files of

Location & "_" & Year

Then create a relationship between the files, linking these calculation fields, and use this relationship to display 'only related values' in your Program Name value list.