Recent content by xraive

well when they are booking a taxi it would look something like this in table 2. The big problem I am having is the fact that in table 2 when I open it up in datasheet view the records are displayed like this: EventTypeDetailsID EventTypeID EventTypeDetailsName Value 1...

I have two tables Table1(TripEventTypes) TripEventyTypeID EventTypeID Table2(TripEventTypeDetails) TripEventTypeID EventTypeDetailID EventTypeDetailValue I am trying to insert multiple records into table 2 from a form. Is there a way to do this? example would be a form for a...

Thanks Mike, I decided to stick with the Travel>Trips>Events>EventDetails Method

Well Mike originally I wanted for every travel authorization there are one or more trips and for each trip there would be trip details which be comprised of Hotel, Taxi, Car Rental... accomodations. But I decided against it because for every leg of the trip you might have 1 or no entries in...

Hi Mike, There is one travel authorization per traveller but many trips per travel authorization. This is for the different legs of the trip.

Hi Mike, Well that's the reason behind the Trips table. It relates to the TransportationType table which consists of different methods of travel for the trip(i.e. Train, Bus, Personal Car, Plane, Taxis...). Now the TripHotels table and TripTaxis table would then relate to every trip. Now...

Also what about linking the Cities.CityID with the Employees.City or Suppliers.City. Does this make it too cluttered

You are right I have about the link between ItineraryDetails.ToCityID and Cities.City. I have redesigned it to look like this what do you think?

Hi All, I am trying to design a travel requests app in MS Access. The program should be able to take flight/car, hotel, or taxi, arrangements and also get confirmation. Every itinerary sometimes requires a hotel, taxi. I have attached an image of the relationhips that I have designed. Can you...

Hi All, I am trying to design a travel requests app in MS Access. The program should be able to take flight/car, hotel, or taxi, arrangements and also get confirmation. Every trip sometimes requires a hotel, taxi. I have attached an image of the relationhips that I have designed. Can you take...