>SELECT Child
>SET RELATION field INTO Parent
>
>I want to display all records in child table in the listbox if Parent record is moved.
>
>E.g
>Parent.field_x = "ABCDE"
>I want to display all child.field_x = "ABCDE" in the listbox.
>
>I've thousands record in child table and I can do that with SQL command, but very slow. I don't want to use Grid!
>
>Thanks
If your indexes are set up correctly, both SQL and grids should be very fast. With the grid you can populate the grid with and SQL cursor or view, or you can use the built-in grid properties (linkmaster, etc.) to set relations. The speed of both depends on having the correct indexes, however.