General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I want to be able to skip to the next record in the parent table, but when I try using a button with the code
>select retail
>skip
>I end up skipping to the next record in the child table instead.
That is how the relation is supposed to work.
you could break the relation, skip 1 in the parent and reset the relation.
Are your tables in a database? If so, consider using a parameterized view. (use the field you were linking on as the parameter, then when you move the record pointer in the parent, all you need to do is Refresh("viewname") to update the child data in the view.) Though a bit more complicated to learn how to do, it'll end up being easier to support - both in the amount of code, and the simplicity of updating the view to add child fields to a form/etc.
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