I have a LookUp query that displays a list of valid WO#'s and WOLine#'s. This is displayed if the User does not enter a valid WO on the screen. When the User selects from the LookUp query, that window closes and the data from the first column(WO#) of the row that is selected is populated into the textbox that the LookUp query is "fired" from. This is fine and works as designed.
Is it possible to also get the WOLine# from the row that the User selected in the LookUp query? Or can I only get data from the first column?
Appreciate the help,