I want to do a search based on a form with a filter througout two tables. There is one table with order data and another table with customer data. I created text fields where the desired values can be entered. The table order contains order specific attributes and is linked to the table customer via customerid. If I look for a specific customer ID the results are fine. If I look e.g. for a name (which can occur more than once) I run into serious problems. I tried DLookup, however I got only one ID of an customer. How do I implement something like DLookup that results me all the ID´s that fit to the entered search term? If there´s a solution for that problem, would it be reccomendable to loop over the result set? How could I do that? I want to get a term like "id = 1 or id = 2 or id = n". Thanks very much for your help!