>>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.

Also, are you changing the index of the Child table at any point? I've done that, and gotten the whole table all of a sudden.

Barbara