Hi J Denaults
You could setup Auto-enter Calculated value to get the Re-Entry Interval from the Pesticides table, you will need to create a link between the Control Agent field in your main applications table and the Pesticides table, if you don't have one already, and I would advise using an ID from the Pesticides table to select your Pesticide, again if not already.
Also worth checking the format of the values in Application Time, are these time formats? For now I will assume they are.
Ok create a field called ReEntryIntervalMax and make it a number and click on options and tick the option for 'Calculated value' under the Auto-Enter tab.
Now in the calculation dialog that pops up input the following:
Max ( Pestercides:: Re-Entry Time )
and click 'OK' and then un-tick the option for 'Do not replace existing value of field (if any)'
Click 'OK' and this will always grab the largest interval time from the Pesticides table whenever you select a pesticide.
Now do the same for the minimum value, so do the same but for ReEntryIntervalMin and input the calculation
Min ( Pestercides:: Re-Entry Time )
Once you do have the Re-EntryInterval fields value in your main application table you can then make your Re-Entry Time an Calculation and input the following:
( Application Time + 60 ) +
If ( ValueCount ( Control Agent ) = 1 ; ( ReEntryIntervalMax * 60 ) ; ( ReEntryIntervalMax + ( ReEntryIntervalMin / 2 ) * 60 ) )
Although you may need to play around with this as I am unsure I have the + 1 hour part right.
And that I think should do the trick.
Let me know if there are any issues or anything that is unclear and you want me to explain more.