How to modify a table containing a foreign key

Question

Hi friends I have a table named bon récéption  and which contains a foreign key Id_marche and in the interface of bon récéption  I filled the combobox of the libélllé marcheshort market the problem is in button modify when I want to modify gives me this error I will extract here my code and the error thank you in advance request Form error

ma ouml · Answer

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

Ramesh Palanivel · Answer

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

ma ouml · Answer

I made instead of = I did in but it shows me this error Incorrect syntax to keyword 'IN'. Incorrect syntax to ''.

Ramesh Palanivel · Answer

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

ma ouml · Answer

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.

Ramesh Palanivel · Answer

HI ma Can you translate this error in English?