Hi all,
I've been trying to research a solution for this but either I am not entering the correct verbiage or it hasn't come up so far.
What I'm trying to do is to basically compare 2 fields and if the primary field is blank to then fill in a 3rd field with the data from the second field. More specifically I have a form that shows the Requested by field automatically and then I have a Requested for field which is to be filled in when the Requested for is different from the Requested by. I want the 3rd field to be populated with the Requested for if it is filled in or if it is blank to use the Requested by field. I've tried to concatenate and substring something but it only works when there is a Requested for filled in. Has anyone run across this before or maybe have a solution?
Thanks,
Mike