I checked out both samples you suggested. The first one is closer to what I need.
I need to build a screen where, when the key value is scanned in/manually entered, the rest of the record would be looked up and brought over to the UI.
Specifically in my case, the QR code on the book will be scanned (or book code manually entered), that book code is used to look up the Lending table and then the UI is populated with rest of the info like lender’s name, date checked out, etc.
It need to start by prompting for one field, then using that lookup the table, populate rest of the UI using the record found.
Tried making the book code field
“searchable” as used in the first example but that did not cause the lookup to happen to bring over the rest of the Lending record.
What am I missing?