Drop-down list w/ data from 4 fields
Hi, I've been ruminating over how to create a value list that includes the data from four different fields within the same record. Here's the scenario:
For a crop rotation, different amounts of manure are applied depending upon the particular crop in the rotation (e.g., soybeans get 4,000 gal/acre but corn gets 10,000 gal/acre). Rotations are planned in 4-year intervals, therefore, there could potentially be four different manure amounts. I would like to take these values (rate1, rate2, rate3, rate4) and include them in a value list.
I cannot put my finger on how to do this and would appreciate any thoughts/insights on this issue.