Searching on searches
I have, through another script, performed a find routine which has, for example, returned 25 products.
I now wish to perform an additional search/find on these 25 results against a user entered date field, X_date, and wish to see all the products that were purchased before that date.
I have 2 databases, 'Products' (for the initial search criteria) and 'Customers' which holds the sold_date field.
Please can you point me in the correct direction.