Is it possible to retrieve duplicate rows during database lookup within Quick Fields and have it populate other fields with the all returned data?
Example:
Table:
001, A Group, A, Z
002, B Group, B, Y
003, C Group, C, X
004, AB Group, A, L
005, C Group, C, M
006, ABC Group, A, N
Laserfiche Fields:
Field 1 (Used to perform lookup):
A
Field 2 (Retrieved values from lookup table):
A Group
AB Group
ABC Group
Field 3 (Retrieved values from lookup table):
001
004
006
Field 4 (Retrieved values from lookup table):
Z
L
N
The customer wants to have an option where they can select the correct row of returned values from the loopup table. If we can provide a list of retrieved rows and the indexer can select correct row from the list.
Thanks!