🚀 go-pugleaf

I've tried to follow the CLASS DATAMODULE EXAMPLE from OLH, but still
can't make this beast do what I want it to!

I have a table of clients (companies) that each have a unique id (COMPID
- numeric).  I have a 2nd table (XREF) of cross references that contains
only COMPID (numeric) and AGENTID (numeric).  The 3rd table contains
agents with a unique id (AGENTID - numeric).

The form has 2 grids on it (one with clients and the other with
agents).  Each client can have multiple agents and each agent can have
represent multiple clients.  The XREF table contains ONLY those agents
who have 1 or more clients.

I have successfully set up the 3 rowsets and the XREF rowset properly
responds when the clients rowset pointer is moved and restricts itself
to just the agent numbers (AGENTID) that correspond to the company id#
(COMPID). The agents rowset does NOT show the correct agents.  

The sql reference is an external sql file produced by the sql designer. 
When it is run by itself, the resulting rowset is correct, but when
placed on the form, the agents rowset is wrong.

The sql designer produced the following (contained in XREF.SQL)
SELECT Agents.AGENTID, Agents.NAME, Agents.CITY, Agents.STATE
FROM "agents.dbf" Agents
   INNER JOIN "xref.dbf" Xref
   ON  (Agents.AGENTID = Xref.AGENTID)  , "clients.dbf" Clients
WHERE   (Agents.AGENTID = Xref.AGENTID)
   AND  (Xref.COMPID = Clients.COMPID)
ORDER BY Agents.NAME


I tried to force a reevaluation of the rowset by reassigning the sql
pointer to itself (form.agents1.sql = form.agents1.sql).  This appears
to be forcing the rowset to reevaluate the sql link (lots of hard drive
activity), but the resulting records do not match what the should be
(wrong agent names). How do I reset the sql link to make it reevaluate
the agents?

Thanks in advance!

Craig
Gator Custom Software
------------------------------------------------------------
"If A Computer Crashes In Cyberspace, Does It Make A Sound?"