General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only