Thread: INSERT in 2 different tables?

Originally Posted by richyrich

I think the best thing to do is work out why the query is returning more than 1 record as that's the only reason I can see why you'd get 5 inserts.

Even if you kept the loop, it would only loop through 1 record then.

Are my presumptions on the performance correct? Should it only be 1 record?

I have put in DISTINCT in the sql statement.. so it should only show up 1 record rite?

the query is supposed to only show up 1 record, you are rite.

but when i de-bug i get this showing up:

Code:

INSERT INTO bookings (performanceID, customerID, bookingDate) VALUES ('3','1','23/11/2009');INSERT INTO performances(Status) VALUES('Booked');0No update permissions!

Rich, the line of code you suggested:

sql=sql & "INSERT INTO performances(Status) VALUES('Booked');"

How does it know which performance it should set as Booked...

hmmmmmmm think we need the performanceID rite?

Originally Posted by richyrich

No idea, I'm afraid. Was just going by your original post

I notice you also have On Error Resume Next in your code. That will suppress any errors you're having with your code.

im such a wally.. have been talking about Insert statements when i really want to "Update" the status based on performanceID