use case, crop planning.
Tables:
1. crop reference (list of crops, planting times, etc.) this reduces having to put crop info (spacing)
2. inventory (i can link to a crop and add the "variety" info, quantities etc.) this worked GREAT!
3. planting schedule (date of planting, variety planted.) I just need to pull ONE variety by choosing from the varieties listed in the inventory. i want this to be fed by available inventory which i'll update regularly.
so in the planting schedule, i want to enter date planted, then choose which one variety i planted using a single select that is populated with the values of the varieties. the tables are successfully linked and i have the lookup values, i just want to choose ONE variety per planting date.
i think i might be linking to the wrong table? or formula needed? see attached...I can't find where "crop copy" is?
