customer lookup

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

Guest

I created a database to store donations reveived for people for a non profit
group I need to know how to set up so when i put the phone number it will go
to the person if they are already in so I dont get dupes.
 
I created a database to store donations reveived for people for a non profit
group I need to know how to set up so when i put the phone number it will go
to the person if they are already in so I dont get dupes.

You can put a Combo Box on the form using the toolbox combo wizard; use the
option "Use this combo to find a record". If it doesn't find an existing
record you could then proceed to add a new one.

You may want to put a unique index on the phone number field to prevent adding
two donors with the same number; however you might want to consider the
possibility that two people in the same household, sharing a phone, might each
want to donate.

John W. Vinson [MVP]
 
John

I made a combo box and put in a dupe of a record i had in and it didnt find
the number as a dupe.
 
Back
Top