Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Lookup based on Zipcode and HouseNr

Hi,
I strugel with an order detail input form.

Here some background information.
I have an orderdetail table with CustomerID to a Customer-table.
The customer-table has a customerID (PK) and also a ZIPCODE, HouseNR and address.

My question;
In the orderentry form (mastertable) want to search the right customer bases on zipcode and house nr.

Problem;
In the lookup option, can only regard to one field. Zipcode or HouseNR?
How can i make an lookup for Zipcode and HouseNR

regards Marcel
1 person has
this question
+1
Reply