Victor,

The combobox whould have the following properties:

Controlsource = "Orders.Customer.Cust_ID"
RowsourceType = 6 - fields
RowSource = "Customer.Name,Cust_id"
BoundColumn=2
BoundTo = .t.

DO not set any relation with "SET RELATION"

Also, you might need a THISFORM.Refresh in the afterrowcolchange event of the grid hosting the order records.

Good luck,

Walter,

>thanks
>Got a pretty good idea what was going on.
>
>I'm not going to continue on this course, cause it wasn't going to solve what i wanted to do.
>
>I'm trying to create a form based on to related tables
>lets say a customer and a order table
>I want to skip through the orders table and change the customer belonging to a particular order. I want to do this using a combobox for the names of the customer.
>
>I thought my first cause of action could take me here but i realise now...
>
>Any comments, suggestions are very welcome.
>
>Tia, victor