Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with skip command
Message
From
13/03/2000 14:04:45
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvania, United States
 
 
To
13/03/2000 11:53:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00345020
Message ID:
00345073
Views:
15
>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
Map
View

Click here to load this message in the networking platform