I have a client that is looking to take a value entered in to a Forms field by a user, use that value to look up data in a database, and then populate the results of the query to a table. Multiple results will be returned when the lookup rule occurs. I then need to populate those results to a table somehow.
My assumption is Javascript will be needed to loop through the results and fill out the table - there will be an undetermined number of results returned.
If anyone has some idea how this would work, I would greatly appreciate your thoughts. Thanks!