I worked it out, and it works great.
What I have are two pages, and I used a URL id for a query for the second page form. I placed the query param (query.id) inside a search input field. The input field is used to automatically look up the data from three tables.
Additionally, the input field can also be manually ‘overridden’ or ‘overtyped’ by the user to query another record if necessary.
Hope this makes sense.
