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

Lookup based on Zipcode and HouseNr

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.

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