Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relationship question
Message
 
 
To
16/06/1999 08:11:41
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00230117
Message ID:
00230648
Views:
23
I am thinking you have too much code. Remove code from page activate. If the error is cyclic relationship, then you have set a relationship from Name_Add into Client instead of from the Client into Name_Add. You also have to design a way of passing the SIN from the first form to the second form. Then you would do a seek of Name_Add for the SIN passed to the second form. Then do a ThisForm.Refresh in the second form. Are the 2 forms using private datasessions? Are the users allowed to switch between both forms freely to change SIN? If so, you will have to place code in the second forms activate to retrieve the SIN value from textbox in the first form to do the seek with.

>Hi Mark:
>
>I entered this code set relation into sin name_ADD and still not working.
>
>I get cylinic error.
>
>The user enters a sin on another form(using client table) and I want the name, address, etc to display from name_ADD on a different form. Sin is a character field.
>
>I have set order to index on activate of form where I want name-ADD
>data to display as follows:
>
>Page Activate code:
>
>select name_ADD
>SET ORDER TO INDEX
>
>
>Probably something simple that I can't see.
>
>Any help is appreciated.
>
>Thanks.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform