Thanks for the quick response, Mark! That seems to work!! I was over complicating it to say the least.
Ok, so Record ID =[Sensitivity Check - Max Record ID] does work in most cases. However, there are some instances where they would go through another table to acquire that information (either Sensitivity Check table or Med Eval Questionnaire Intake table). So when I try to compare the 2 to pull the most recent record, I'm getting an operator error with this formula -
If([Sensitivity Check - Max Record ID] <> "",[Sensitivity Check - Max Record ID], [Med Eval Questionnaire Intake - Maximum Record ID#])
Where am I going wrong?
Qrew LegendTo check a numeric field type for blank, you can't compare to empty quotes. That only works for a text field type.
Set the field properties fir that max Recird us field on the relationship to not treat blank as zero.
then change yiyr furnuks to this
If(not IsNull([Sensitivity Check - Max Record ID]), [Sensitivity Check - Max Record ID], [Med Eval Questionnaire Intake - Maximum Record ID#])
Qrew LegendTo check a numeric field type for blank, you can't compare to empty quotes. That only works for a text field type.
Set the field properties for that Max Record ID field on the relationship to not treat blank as zero.
then change your formula to this
If(not IsNull([Sensitivity Check - Max Record ID]), [Sensitivity Check - Max Record ID], [Med Eval Questionnaire Intake - Maximum Record ID#])
