I have a simple table to track our phone calls made to our truck drivers.
The call logs are entered into a form, using a drop down list lookup to populate driver's name that was called in each record. The driver's names are listed in a separate table from the call logs.
Now, when I create a query to narrow down the call logs made to a specific driver, I get an error message telling me that my criteria is too complex.
So, it seems to me it can't find the driver's names. I know there is a way around this, but cannot remember how.
I could have the users run the general query and then filter manually to the specific driver, but that seems cumbersome, and I don't want users changing the query in error.
Any direction would be greatly appreciated! Thanks!