searching through records

[lonesoac0]

Hello all,



I am building a database and I built a form for customer entry. Now I want to populate that form based off of query search results. 99.9% of the customers will have a unique identifying number and will be easy to find with a query. My concern is that there will be some users that forget their unique ID and will need to be found. The flow that I envision is that a customer walks in with no number, we search by his phone number and name. A selection box is populated by the search results, the correct user info is selected and then the an arrow button is clicked to populate my form. What do you think? Too complex?

[ranman256]

ALL customers should have an ID (autonumber) along with your in-house ID that 99% have.
Even if they don't know the #, you can search by name. Then when you have the correct customer showing, click a button and a query will populate the form/table
with the data.

[lonesoac0]

Yup. You are 100% correct on the ID number. I have an auto number ID and the in-house number which is actually an external number from another org.