Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One To Too Many
Message
From
08/04/1997 23:51:02
 
 
To
08/04/1997 04:21:37
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00027378
Message ID:
00027536
Views:
26
>I am constantly having the following problem: I create a one-to-many form (without using the wizard). Everything sets up and works beautifully. Then, as I continue to de-bug the form, my grid suddenly begins showing ALL records in the child table rather than just the ones that belong to the selected parent.
>
>EXAMPLE: I have a RENT table and a RENTEQUI (rent equipment) table. The following properties are set in the grid:
>
>LinkMaster Rental
>RecordSource RentEqui
>RecordSourceType Alias
>RelationalExpr RentNo
>
>I select a customer. The DE relationship moves the Rental table to the proper record: the first rental on file for the selected customer. The grid of equipment that belongs to this rental starts at the correct record, i.e., the first equip. for the target rental. However, I can scroll up and down through the entire table. Why? How do I fix it?
>
>TIA.
>
>John

You forgot the 'CHILDORDER' property.
System Analyst
Nabil B. Ghrayyeb
nabilg@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform