I am trying to pull in details of a client in row based on the code entered by the user using the app’s scan function. I have tried using “dereference.” that works well but it relies on the use of “ref” which means a pull down menu. There are too many rows to use a pull down menu and the user will not be able to remember the code. “Lookup”
may be the way to do this. Are there alternatives?