Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Skip record in child table
Message
From
11/11/2003 09:34:40
 
 
To
10/11/2003 19:08:05
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00848202
Message ID:
00848682
Views:
14
Yes, I think I will do that parent ID condition at moving records.
I just wanted to find out is there some generic solution. This way I must write specific conditions.
Or maybe not, I will think of something :).
Thanks for help...

>>I have tried that on my Form and no result.
>>Maybe I didn't describe the problem.
>>I have GRID on a table that RecordSource = "ChildTable", LInkMaster = "PrrentTable" and RelationalExpr = "Parent_ID".
>>I have two buttons on a Form that do SKIP 1 and SKIP -1 in a ChildTable.
>
>Ah. I see. Yes, that's a different issue and Cetin gave you the SET KEY solution, which is alright, except it limits you in what order you can display records in. However, it's fast. I've used it in the past. Otherwise, you can simply add conditions in your skip code to test not only BOF and EOF but whether the child table parent ID matches the parent's. Think of moving past the parent ID as the same sort of issue you'd face with the beginning and ending of the file.
>
>>Now, problem is that Grid is showing only child records that are related to parent ID and that's ok, but when for example I do SKIP 1 when in the Grid is the last row then record goes beyond that relation and goes to record in ChildTable that is related to next Parent_ID in ParentTable.
>>I don't want that, and I wan't to solve that.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform