AnsweredAssumed Answered

Drop-down list w/ data from 4 fields

Question asked by k1ngf1sher on Mar 29, 2010
Latest reply on Mar 29, 2010 by philmodjunk


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.