cmd = [exec InTransitRN ?']+fdBlNo+[']So basically I want them to be able use the above if they have that number, but also search on this one:
cmd = [exec InTransitRN ?']+fdRefNo+[']Is there a way to combine the two somehow or does it have to be done separately? Would a CASE statement work here? I was thinking of having it check to see which text box had data in it and use the associated code based on that. I don't know if that's a good way to do it though.