S
SJJ via AccessMonster.com
ok
now i have 2 tables as u mentioned
tblcustomerdetail
tblbooking
in tblcustomerdetail table contactID is the primary key
in tblbooking date and time are primar keys also the fields are follows
contactID, OrdinaryEventID,OccasionalEventID,EventName,BookingType
i made a query to pick all of the customer details and booking deatils for
ordinary bookings.
the query called qryOrdinaryBookings
so i made a form and the recod source is qryOrdinaryBookings
however i cant type anything on some of the the fields, which are from the
tblbooking? why is that?
i can type the fields which are coming from the tblcustomerdetail but it bot
saving on the form.
once i closed the form everything is gone. open like a new form
wat do i have to do... so all the data will be on the form to look back.
now i have 2 tables as u mentioned
tblcustomerdetail
tblbooking
in tblcustomerdetail table contactID is the primary key
in tblbooking date and time are primar keys also the fields are follows
contactID, OrdinaryEventID,OccasionalEventID,EventName,BookingType
i made a query to pick all of the customer details and booking deatils for
ordinary bookings.
the query called qryOrdinaryBookings
so i made a form and the recod source is qryOrdinaryBookings
however i cant type anything on some of the the fields, which are from the
tblbooking? why is that?
i can type the fields which are coming from the tblcustomerdetail but it bot
saving on the form.
once i closed the form everything is gone. open like a new form
wat do i have to do... so all the data will be on the form to look back.