I posted this yesterday, but it got lost somehow.....

My form has three tables in the dataenvironment, in a parent-child-child relationship. I set the filter as a property as follows:

Parent: None
Child1: Child1.key = Parent.key
Child2: Child2.Key2 = Child1.key2

The data from each appears in a standard listbox, with a RowSourceType of 6 and a RowSource as appropriate, usually the description field. The Child2 table listbox has a rowsource of 4 fields, numeric/character/datetime/numeric.

In the InteractiveChange event of lstParent, I issue:
lstChild1.Requery
lstChild2.Requery
In the INterActiveChange event of lstChild1, I issue:
lstChild2.Requery

The lstChild2.Requery is suddenly returning a "Syntax error" error message. There is no code in the lstChild2.Requery event. It has been working fine, and just developed this twitch.

If I change the RowSource of lstChild2 to eliminate the first column, it seems to like it better, but I haven't really road-tested it.

Clues?

BTW, this is VFP 3.0/Mac.