Query Complexity in FP

[Mr. Know Nothing]

I am having alot of trouble with a query in FP. I was wondering if FP has a
complexity limit on the queries that it can handle. Namely, my query has an
inner join but I have writen it in every way I know how without joins and
everything that I can find on the internet doesn't help. If anyone has any
idea how to make complex queries that workin Access work in FP please let me
know as you would be a great help.... Anyone??

(specific exmaple:
2 table, Customer and CallLog
Customer has fields: customerID, Fname, Lname.......
CallLog has fields: CustomerID, CallLogNum, Status, ProblemDesc

I want all fields from CallLog but the only piece of info I have is
customer.Fname my query is:

SELECT CallLog.*
FROM CallLog, Customer
WHERE (((Customer.CustomerID)=[CallLog].[CustomerID])
AND ((Customer.Fname)=::Fname:);

Now this query works in Access but when i try to use it in FP i get the
following error:

Server error: Unable to retrieve schema information from the query:

SELECT CallLog.* FROM CallLog, Customer WHERE
(((Customer.CustomerID)=[CallLog].[CustomerID]) AND ((Customer.Fname)=1));

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/Customers.mdb.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Type mismatch in expression.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)

Now I know my page is working as if I use (select * from CallLog) i get the
full table so i know the problem is in the query itself or FP.)

If I missed anything to explain my problem let me know.

thanks in advance