Jump to content

Value list drops "second value"


TonyInSeattle
 Share

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

Recommended Posts

SHORT DESCRIPTION OF PROBLEM: How do I keep the "second value" in a value list from disappearing if the relationship between the two tables is no longer valid?

LONGER DESCRIPTION: I have two tables: PRODUCTS and SEASONS. Every product is assigned a season via a value list, and the season ID is the match field that links the two tables. The value list is defined to show only the "second value", which is the friendlier season name.

Users can "close" seasons on seasons pages, meaning that the seasons have passed and will never be chosen for new products. I want a closed season to not be available in dropdown lists to keep the list from growing ever longer as years pass.

To accomplish this I have a second match field between the two tables. If a season closes, the fields no longer match for that season, allowing the value list to show only open seasons.

Here's the problem: If I return to a product page from a "closed" season, the season ID of the closed season is still stored with that product. But the Season Name has disappeared from the field. How did I get it to stay? All I see is the Season ID.

POSSIBLE SOLUTIONS:

I could create a second occurrence of the SEASONS table (SEASONS 2), where only Season ID is the match field. I could put a Season name field from the SEASONS 2 table over the Season ID field from the SEASONS table. But this seems clumsy. And will it even work with Instant Web Publishing?

I was hoping I could just change the table in the value list to store the season ID from the SEASONS table, but show only the season name from the SEASONS 2 table, but that did not work.

Any other ideas? See the attached for a mockup.

THANK YOU!!

Seasons_problem.zip

Edited by Guest
Link to comment
Share on other sites

This topic is 5773 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
 Share

×
×
  • Create New...

Important Information

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