finding matching records

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

Guest

Hi Al

I have a form with fields called "customersname" & "customersaddress". I use an autonumber as the primary key.

What i would like to be able to do is when entering a customers name or address i would like it to bring up any other records that match either the customersname or customersaddress. I would like the records to appear on this form so that it is easily identifiable if we have received letters from this person or address before

I can't figure it out for love nor money.

I would really appreciate any help

Thanks agai

Carol
 
Hmmm. Do u have a table with CustomerID, custname, custaddress and a table
called Correspondence that has as a foreign key the CustomerID. The
relation is one to many....
Then when you access the customer form you can show the correspondence in a
subform, or you can create a form that has a list of customers, that when
one is selected, shows the correspondence fields.
It wasn't clear from your question if you have the correct table setup....
You need to start there.

Damon

Carol M said:
Hi All

I have a form with fields called "customersname" & "customersaddress". I
Click to expand...
use an autonumber as the primary key.
What i would like to be able to do is when entering a customers name or
Click to expand...
address i would like it to bring up any other records that match either the
customersname or customersaddress. I would like the records to appear on
this form so that it is easily identifiable if we have received letters from
this person or address before.
 
Back
Top