How to modify a table containing a foreign key

Of course will be executed in sql by cons in visual the problem is that I filled the combobox with a property referenced to the foreign key

Hi ma,

Run the particular query in sql server and try ,whether its working or not

I made instead of = I did in but it shows me this error

Incorrect syntax to keyword 'IN'.

Incorrect syntax to ','.

Hi ma,

In id_marche=(select....) with in query you have used where "=", Instead of that use IN.

Try and let me know if it has any issue again

Here it is

The subquery returned several values. This is not allowed when the subquery follows =,! =, <, <=,>,> = Or when it is used as an expression.

The instruction was stopped.

HI ma,

Can you translate this error in English?