Apollo set relation help

For programmers who have experience with [login to view URL] database driver. We use Version 9 right now. If you do not know apollodb do not quote. You must have apollo and all dlls needed. we are not providing anything. we are looking for someone to just help us solve the problem below. Only paying for a working code that works with apollodb asp.net database controls. Our request is simple. Create ASP.net application that takes two dbf and joins them via set relation command in apollodb and allows us to query the two databases using indexes. We will test with two databases of 100k in size to make sure indexes are geing used. This is not a actual project I just need to see how to do this code properly because it is not working for us and need a solution. Apollo support is non responsive and we need a solution Desc: We are trying to create a relation between 2 DBF tables. Both tables have an index named "IDREC" When we set the SetRelation command from the master to the detail table it is now working. Code: -- OPEN PARENT TABLE -- tableF = New ApolloTable() [login to view URL] = "PATH TO TABLE" [login to view URL] = "ALIAS FOR MASTER" [login to view URL] = [login to view URL] IDF = [login to view URL]() [login to view URL](1900) [login to view URL](0) [login to view URL](True) -- OPEN CHILD TABLE -- tableD = New ApolloTable() [login to view URL] = "PATH TO TABLE" [login to view URL] = "ALIAS FOR DETAIL" [login to view URL] = [login to view URL] ID = [login to view URL]() [login to view URL](1900) [login to view URL](0) [login to view URL](True) -- SET RELATION-- [login to view URL](ID, "IDREC") -- TRY YO FILTER USING A INDEX IN THE DETAIL TABLE -- Qres = ApolloAPI.sx_Query(" Language='English' ") -- WE ARE GETTING BACK ALL ROWS IN THE MASTER TABLE -- -- WE SHOULD GET JUST THE ONES MATCHING THE FILTER -- Needed working code that we can comple working exe to test should open two dbs and set relation then show a grid of the two dbs showing that the tables are joined and using indexes. Also should be able to set a filter using setscope or set filter command to show it also using the set relation in those results.