Is it possible to move a record from 1 tbl into another and add fields from a 3rd tbl

[kimberlymikado]

I am creating a database for a small travel agent.
I would like to move the record of a holiday which is in an AvailableHolidays table to a BookedHolidays table when a customer books the holiday, i would also like to add the CustomerID to the record in the Booked holidays table, is there an easy way to do this?

[missinglinq]

Your post is somewhat short on info, but as a general approach, I would have a single Holidays table, not two, with a check box called "Booked." When the holiday is booked, you check the box and fill in the CustomerID, or you could have a combobox based on the Customers table, and when the "Booked" checkbox is checked, have the combobox dropdown and enter the customer data that way. To force the entry of a CustomerID if the box is checked, you could make selecting an ID mandatory.

Instead of having two tables, you could have 2 forms based on queries from the Holidays table, one for booked holidays and one for available holidays. The forms and queries would be essentially identical, the only difference being whether the "booked" checkbox was checked or not.

Get the idea?

Welcome to TheScripts

Linq ;0)>

[kimberlymikado]

Thanx, that makes sense and would be so much easier than what i was trying to do. Really wasnt having a good MS access day!

[missinglinq]

Glad we could help! This same technique can also be used when you want to "delete" a record but archive a copy of it. You simply check the box to mark the record as "deleted." If you need to re-instate the record, you simply uncheck it!

Linq ;0)>