Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Effect of SET RELATION in forms
Message
 
 
To
17/01/2001 10:39:54
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00464658
Message ID:
00464677
Views:
12
If you use table buffering instead of row buffering, then moving the record pointer won't inadvertently save anything. The inadvertent save is the main reason I avoid row buffering.

>I have a 1-1 relation set between 2 tables, and fields from both tables mounted on a form. The relation is set as so:
>
>
>use hours in 0 order wcode
>use main in 0 order wcode
>select hours
>set relation to wcode into main
>
>
>Fields from table main are informational, with the text boxes set as not enabled. When a user adds a new record in the hours table, the first thing that happens is that they must enter a work code. I would like the relation to take effect and show the corresponding information from table main. As it is, you have to move off the record and come back to get the information to show up. Refreshing the form does no good unless you move the record pointer and return to the record. These tables are set up with buffering, and in the middle of a new add, I don't want anything inadvertently being saved, which will happen if the record pointer is moved.
>
>Any help is appreciated
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform