>>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
>
>Hi John,
>Force the relationship manually in the load event of your form
>with:
> SELECT rentequi
> SET ORDER TO rentno
> SELECT rent
> SET RELATION TO rentno INTO rentequi
>
>Hope this help.

Luis:

I tried what you said--worked like a charm! Thanks for the assist--I really appreciate it.

John