>Hi everyone,
>Its friday and I'm probably brain dead but...
>
>I have a form with a DE defined with two tables A & B
>A relation is set between the tables as follows,
> A is the parent to B
> One-To-Many is .T.
>
>On the form I have a Listbox with the RowSource set to ALIAS,
>and the RecordSource set to A.Name
>
>Also on the form is a grid with its RecordSourceType = Alias and
>its RecordSource = B
>
>The problem: The listbox shows a duplicate entry for each record
>in B, I only want one entry in the listbox with all the child
>records in the Grid
>
>TIA
Ray,
When rowsourcetype is set to alias you force rec pointer to move in actual table. Changing it to SQL could be better.
Cetin