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????
