I have two fields, shop # and code date. If the shop # is blank, I want the code date to calculate as it is currently doing. If there is anything in the shop #, I want a Look-Up to control the code date (looking up the value from another session).
I apologize for the late response. I wonder if you could use form logic to make a decision like this. Form logic is available via the Form Designer (Right most button on toolbar). This area of code allows you to write custom event-->Action handling and may be useful for this kind of decision branching.