Set classlib to f:\work\lmsql\lmdata lo=NewObject("lmdata") lo.Jobs.CursorFill() lo.Customers.CursorFill()... and WOW, I get two VFP-looking cursors from my SQL Server (which is running on some other test machine I have running on my network).
*-- Open child tables ---- select 0 use Customers order custno select 0 use Materials order jobno select 0 use TimeRecords order jobno *-- Open Parent Table ----- select 0 use Jobs order jobno Set relation to custno into Customers Set Relation to jobno into Materials additive Set Relation to jobno into TimeRecords additiveNow I have the pointer in each of the Child tables table moving when I move the Jobs pointer...I rely on this very much in the navigation structure and processing and display of data in my app. I use a VCR control to move around the Jobs table, as well as a lookup textbox to jump straight to a certain Job, but then I need all the Child cursors to be in synch also. In total I may have about 6 to 8 child tables that I need to have in synch with the Jobs pointer.