Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting up relation on index view
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Setting up relation on index view
Miscellaneous
Thread ID:
00617525
Message ID:
00617525
Views:
58
I'm not sure if I am going about this correctly, but what I am trying to do is create a relation between two views. What I have is a parent view called lv_veh (primary key is v_id, and I have a child view called lv_ser (foreign key is s_id). In DataEnvironment.Init I create the indexes. I'm not sure how to create a relation between lv_veh.v_id and lv_ser.s_id. Is it also ok to create two indexes on view in dataenvironment as shown below?
What I am after is when I move to different record in lv_veh, I what the child lv_ser records to display correct linked records in a grid. For example if lv_veh.v_id = 20, then I want all lv_ser to show me all records s_id = 20.

CURSORSETPROP('buffering',3,'lv_veh')
SELECT lv_veh
INDEX ON v_id TAG v_id
CURSORSETPROP('buffering',5,'lv_veh')
CURSORSETPROP('buffering',3,'lv_ser')
SELECT lv_ser
INDEX ON s_id TAG s_id
CURSORSETPROP('buffering',5,'lv_ser')

Thanks
Nick Patel
Next
Reply
Map
View

Click here to load this message in the networking platform