I am using a UD table to track some data where I have Key1 as a unique number and Key2 as a job number. The users never see Key1 since all they really care about is the job number.
I have been trying to build a search button into my UD form that will allow the user to search by job number (Key2). I built a quick search to allow then to search by Key, which returns the proper search data from the BAQ. However it never returns any data to the form. I read on this site to have it use SysRowID but every time I try to put SysRowID on the form either as a textbox or in the list grid it always reverts to not visible, so I can’t seem to be able to build a quick search off of it.
Does anyone have any suggestion of how I might be able to get the quiick search to return the data requested?