Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating relations in form data environment
Message
 
To
24/07/1998 11:25:07
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00121008
Message ID:
00121039
Views:
20
>Can I create a relation (non-programatically) in the data environment of the form designer between 2 views? I am able to do this when the target is a table with a primary key, but when the target is a view, I am unable to do it.
>
>
Bob,

Relations are from an expression to an index key. Your views don't have indexes so you can't relate them. You can, in the form's load do something like this;
SELECT View2
INDEX ON Field TAG Field
SELECT View1
SET RELATION TO Expression INTO View2
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform