|
Title: Travel Databases Post by: oceangirl on March 06, 2007, 06:08:37 pm Hi,
I wonder if you can help me. I am trying to design a database or excel spreadsheet that will show all the various changes that have been made to an individual’s business trip. I have to book trips for about 100 different people (No kidding!) And for the most part they are straightforward simple ones with no changes and for most of the time our normal method works. Our travel company deals with tickets and e-tickets and provide me with a reservation number, which I can access through the Internet and give to the traveller. Normally this is enough, however, for example, I have got some guys over in Saudi whose tickets are now unable to be changed by our travel people and I have had to do it for them. And our travel company wont be able to see the latest info nor make any changes to the flights. Hence the need for a database in case I get hit by a bus. Someone needs to be able to see what is going on. Does any body have any ideas? I want to be able to dump all the stuff that is currently written in my notes into a database so that I can go on away safe in the knowledge that everything is written down and I don’t have to worry. I was going to do it in excels but I can’t think how to do it. Then I had a look at Access and got even more confused then I got to thinking there must be other people who book travel and have issues. The database/spreadsheet would not be for invoicing as this already tracked and recorded in Access (too large for excel!) for recording invoice detail prior to entry in S A P. (Oh Joys of Joys!) Any Ideas? Georgie Girl. Title: Re: Travel Databases Post by: countrigal on March 09, 2007, 02:33:28 am Well, since my love is Access, I'd want to do it in Access. Using the reservation number, or another unique identifier, you could put all the basic info for the trip in this format. Then if you have changes, you could pull up the reservation number and make changes or annotate them in a field such as "comments" but perhaps named "Changes".
I'm not really sure what you're trying to track, other than the fact that you've been making changes to these tickets and why. This seems to be a straight forward way of tracking those, and an Access database could be searched and arranged by reservation number or by employee or location or whatever field you enter. Can you give a bit more of an idea of what you'd want to do with this database, and we could probably give a bit more of a response. CountriGal Peer Moderator |