updating table

[maarit]

Hi,

I have three tables, customers, shops and customershops.
Table customer have rows name Id and customername.
Table shops have rows id and shopname,
table customershops have rows id, customerID (=same as table customer id) and shopid (=same as table shop id)

Now I want to update table customershops.
The user can select customername and shopname from the form.

But how can I update table customershop rows shopID and customerID.

Please help me.

 

[Cagliostro]

I think you need not an update but an insert query:
insert into customershops
(
customerid,
shopid
)
values(select customerid from customer where customername='xxx'), values(select shopid from shops where shopname='yyy')
John Fill

ivfmd@mail.md