Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
ON INSERT INTO tblTripClient [valTripNo] = tblTripClient.ClientNo [valBookingsCount] = (SELECT COUNT(*) FROM tblTripClient WHERE TripNo = [valTripNo]) [valBookingID] = tblTripClient.TripClient [valTripType] = (SELECT TripType FROM tblTrips WHERE TripNo = [valTripNo]) IF tblTrips.TripType = “ST” Then IF Bookings.Count MOD 10 = 0 Then • INSERT INTO tblStudentTrip SET StudentLast = ‘Chaperone’ AND StudentFirst = ‘Adult’ o Set Additional fields, too! This includes TripNo… This will now be used to flag the tripno that the chaperone is for, and will be visible on the Kelly Tours client/travelers page, along with the “booking” at 0 use cost o [valTravelerID] = tblStudentTrip.ID • INSERT INTO tblTraveler_lkp SET ClientID = 42859 AND TravelerID = [valTravelerID] AND FamilialRelation = ‘Teacher/Chaperone’ • INSERT INTO tblRoomingLists SET TripClient = [valBookingID] AND TravelerID = [valTravelerID] AND RoomNumber = 0 AND HotelNumber = 0 AND BusNumber = 1 AND ListName = ‘Traveler Manifest’
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!