Walter Meester
HoogkarspelPays-Bas
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement