Find Record using Query

[tomself1]

Hi guys,



I'm designing a point of sale database, but I'm having a problem working out a way to call up customer details. Basically, when someone buys something, the products are scanned and the details are logged. I have a table of customer information and I'm looking for a way of calling up customer details from just their postcode or their name.

So for example, the shop assistant can just put their postcode into the system, and it assigns their customer ID to that particular sale. If more than one customer comes up for that post code, it asks more questions, such as first name. If no details come up, it can then prompt to create a new customer.

Any ideas are much appreciated!

Cheers,

Tom.

[kennejd]

A query joining the 2 tables should work...what have you got so far?

[tomself1]

Well, I've created a query that shows all customers, based on a surname & post code input. Unfortunately, I haven't found a way to either select on the correct record in the query, when there's more than one that meets the criteria.

Cheers!

[kennejd]

Can you post the sql?