Hi,
I've got a child table called: Booking for saving user bookings, with three parent tables namely: User, Venue, and Booking Type. All in an Access DB, now here's my scenario: I want to insert data into the Booking table depending on on the type of booking the user selects like so:
1. if booking type is meeting, then only userID(FK), startDate, startTime, endTime, and venue must be saved, including booking type ofcourse.
2. if booking type is leave, then only userID(FK), startDate and endDate must be saved, including booking type ofcourse.
2. if booking type is other, then only userID(FK), startDate, startTime, endTime, and description must be saved, including booking type ofcourse.
In essence, the only required fields are: userID, bookingType, startDate, and the rest are optional.
I want to achieve this in VB, and I am a newbie.
Enter your message below
Sign in or Join us (it's free).