Cascading conditional lookups, keep final result only?
I've got a 4 tier conditional lookup working now. How do I store just the end result?
Inventory has a field called code. This is an abbreviation I can use in a relation to pick up any chunk of the related species I need.
Plants has large amount of information about each species/cultivar I grow.
I have a 4 tier set of conditional lookups. They mostly work. E.g.
Class has a choice of Leaf or Cone. Pick Cone. Genus now has a list of Picea, Abies, Larix Pick Larix. Now I have a choice of larcina or siberica. Pick larcina. Now I have a choice of code of LarLar.
Ok that works: Sort of.
1. As soon as I make a pick from the top tier, how do I clear the next ones.
2. At the 4th level there is only one possible code. But I still have to click it to make it change. How do I default to the first available value?
3. I don't want to do all of this in the inventory table. I only want to store the final code in the inventory table.
At present my tactic for this is to add a third table "Do_Lookup" that actually does the lookups. Once code is determined, a script updates the current inventory record with the value of code, then deletes the single record in do_lookup. Is there a better way to do this?
(Eventually, Code will have a button that will bring up a popover to do all of this.)
Barking up the wrong tree? Barking mad?