help with addresses

  • Thread starter Thread starter Colm O'Brien
  • Start date Start date
C

Colm O'Brien

Help please

I want to record addresses in a table, clients can then be linked to these
addresses. I want to have a form and once the post code is entered and a
command button clicked the table would be checked for any which match and
shown with the number of the house. If the address already exists a command
button will close the form if not a new address can be entered. The only
thing is i don't know how to start.

thanks for any help.
 
Start by creating a Clients table, and an Address table.

In the clients table, use an autonumber for client id (only because it's a
bit easier) in the address table, make sure you have a client id field with
a long integer datatype. Use a form/subform to display and edit the data.

An example to follow is the Orders/Order Details tables and form/subform in
the Northwind sample database.
 
Back
Top