Jun 23, 2008 01:46 AM|geosync|LINK
Yes, it is possible to join these two tables, and even a third...
I'm wondering if your syntax for table joins is correct: what database engine are you using? (Looks like maybe Access.)
Does this query work directly in the DB environment (i.e. Access)? Make it work there first, then you can track down why it isn't working in your FormView.
When you tried joining these tables, what happened? What error?
As far as alternatives go, I believe your best alternative is to make the query work. <grin>