Copy From one table to New Record

[RichGags]

I have a Quotes table with clients info, and a bookings table. When people are shopping, they are in our quotes file. When the want to book, I want to create a new record for them in our bookings file.

I tried doing this with an update query, but Im not having any luck.

Most (not all) of the fields in the quotes table will be transfered to the bookings table. The bookings table, when adding new records has an autonumber field. (I dont know if this matters). Thanks.

 

[Pat Hartman]

Take a look at the many-to-many sample db that I posted a few months ago. You can do this with a main form that shows the quote data and a subform that shows the booking data.

 

[RichGags]

That would be great, but Im migrating from an Old Q&A database where many of our customers have 2 or 3 records already (with duplicate data) and I need to keep all these records. Also, people only stay in my quote file for a week or two then I delete them.

Is there another way just to copy info from 1 table to another table as it adds a new record?

Thanks.

 

[neileg]

That would be great, but Im migrating from an Old Q&A database where many of our customers have 2 or 3 records already (with duplicate data) and I need to keep all these records. Also, people only stay in my quote file for a week or two then I delete them.

I don't see why you can't normalise your data. It's a one off exercise, and a few select and update queries would have this sorted. I would expect this to be easier than trying to fudge your solution in the way you are thinking.