Searching records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All - I am developing Video Rental application. I want my client to click
on Customer form and at the bottom of the form I have several buttons. One of
the buttons is search. My client can here either enter a new record or else
can just enter either First Name or Last Name or Phone number and click on
search and the application will find any existing records and display them.
If my client enters First, Last and Phone number, the application will only
find relevant records. So lets say First Name is not found it will
automatically look at the last name. How do I create such a search function
without creating a search form. I basically want to use one form and at the
bottom I have add, update, delete and find functionality. Any help you can
provide would be greatly appreciated.
 
That doesn't make sense. The implicaton of you having an 'Update' option is
that the form is displaying a single record. Wanting to also have a search
facility implies multiple records.

And why insist on a single form? Standard procedure is click on a 'Find'
option and enter parameters (i.e. on a second form). I'd suggest thinking
in more detail about what you want and reposting.
 
Rob - I agree with what you are saying but I am looking more from UI
perspective where end user doesn't have to go through multiple forms. The
Update button at the bottom is if a customer has some changes to the account
detail for e.g. address change then that can be accomplished. The search
button or after update event will basically see in the database if the record
exists. Customer phone number is the primary key so once an end user enters
the customer number, the application will pull of the customer record. If it
doesn't exist then it will allow an end user to add a new one. Hope this
clears any confusion.
 
Forgot to mention. I have created a query based on what is entered in the
text book to look it up. This works however it opens the query in query
output as opposed to displaying data on form.
 
Back
Top