i need help!
well basically, there is two of them!
the first one is:
i have a tblBooking.DateOfOrder and i want to make the date in this field not exceed the date in tblOuting.DateOfOuting
ive tried:
tblBooking.DateOfOrder<tblOuting.DateOfOuting
The second one is that i have created the database, with a tblCoachDetails and within that table there is a field called NumberOfSeatsAvailable, and what i want to do is with this is to make sure that when orders are placed, is that i dont want there to be more booked seats (tblBooking.NumberOfSeats) than avaliable.
can u help?