Make field(s) available in database based on selection in a different field(s)

Based on this thread I started in Get Help.

I explored using back refs or highlights, but I want to have a more structured and consistent relationship pattern, so migrating my Get Help question into a feature request/idea.