Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Many 2 Many in Data Environment for Form?
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00172152
Message ID:
00172291
Views:
19
Michael,
Check the SET SKIP entry in the VFP Help. That said, I feel I must also push you back to PViews. I have several of these many-to-many relationships in one app. and the PViews work superbly. They also allow me to show descriptions from lookup tables instead of the code values stored in the main data tables. PLEASE keep working with them.

HTH
Barbara

>I have a many to many relationship established, using an intermedaite table to link index values from both tables.
>
>I used to handle the display of a grid of related records in my forms by using a view, and requerying the view whenever changing records.
>
>I was hoping I could eliminate the added overhead of querying the view by just creating a one-many relationship in my data environment (either between the parent and intermediate table, or for both relations) - but when I try this, I still see only one child record for each parent!
>
>I don't know if I'm doing something wrong, or if the intermedaite table is creating a level of complexity which doesn't allow the desired result. I could go back to the views (or sql into cursor), refreshed for each record - but if I'm missing something that would make my life easier and my application faster, I'd like to learn about it!
>
>TIA
>
>Happy NewYear!
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform