Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem Navigating Through Records in a One-to-Many Form 1

Status
Not open for further replies.

tiptonb1

Programmer
Mar 27, 2001
5
US
I have a form with a main table and two child tables setup in the data environment with one-to-many relationships. I am using the VFP provided txtbtns class in the Wizstyle class library. When I select the next button, the main form doesn't advance to the next record. After investigating, I found that the form is navigating through the child records before it will advance to the next record in the parent table. (e.g. if the child table has three records it will take four clicks of the Next button to advance to the next record in the parent table). I'm pretty new to the Visual part of Foxpro and have not experienced this before. Any advice is welcome.
 
Hi my friend,
Check you SET SKIP TO, for example use the command
Code:
WAIT WIND SET("SKIP")
From the help,
SET SKIP TO Specifies the aliases of multiple child tables. These are used to create a one-to-many relationship with a parent table. Use commas to separate the aliases. In commands that support a scope (DISPLAY, LIST, and so on), records in the parent table are repeated for each corresponding record in the child table.
The colored line is exactly what are you suffering from.
I hope I made a good gusse.
Thanks

Walid Magd
Engwam@Hotmail.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top