Hey there i'm new, i was searching around for some help on MS Access and wondered upon this here forum.
I just need a quick bit of help..
I've got 2 tables, TBL_Venue and TBL_performer
and i need to append some data into a bookings table
now i've got the venue_id (PK of TBL_Venue) and performer_id (PK of TBL_Performer) i need to get into the bookings table.
How do i go about using a query to create a booking.
My bookings table has:
booking_id, venue id, performer id, date beginning of booking, date end of booking.
thanks

I've got 2 tables, TBL_Venue and TBL_performer
and i need to append some data into a bookings tableSome data from both tables???now i've got the venue_id (PK of TBL_Venue) and performer_id (PK of TBL_Performer) i need to get into the bookings table. How do i go about using a query to create a booking.Using a query to create a booking??? Queries usually don't do this. Are you referring to creating new records in the "bookings" table?? Use a form for data entry. If you are not talking about entering data into the "bookings" table, then please elaborate a bit more on this, because I'm not sure what you're talking about...

oh ok yes sorry about that.
ok basically i need to work out how to create an append query so i can add records from TBL_Performer and TBL_Venue into TBL_Bookings.
What i intend to do is have the performer and venue records added into the bookings table effectively creating a "booking". Then as this will be done through a form i'll have other things to append into TBL_Bookings as well.
But basically i need to know how to append data from one table into another

Then as this will be done through a form i'll have other things to append into TBL_Bookings as well.If you're wanting to just create records in the bookings table when a booking is requested, then an append query is not needed. When you say "append records", I think you mean, "take VenueID and PerformerID and add those to the bookings table along with the booking details". Right? For this, all you need is a form with a recordsource of the bookings table. Then, on that form, you will need two combo boxes, one to lookup the VenueID and one to lookup the PerformerID. All the controls on the form will have control sources with them (so they can be inserted into the table). Have I gotten it now?