I'm very new to VB and trying to build a project using the Data Environment Designer. I have created a shape that has a parent table and three child tables. In my code I want to do a filter on the returned record set such as

DataEnvironment1.rsCD_INVENTORY.Filter = FindString

and my FindString contains the field I'm filtering on and the value such as

"FILENAME LIKE 'test%'"

but I get an error saying


Run-Time error 3265

Item cannot be found in the collection correspoinding to the requested name or ordinal


This column is in one of the child tables, not in the parent. If I use this same code but have my FindString value such as

"DESC LIKE 'test%'"

it works fine. The difference is the DESC column is in the parent table and the FILENAME column is in one of the child tables. How do I reference a column in the child table????