I am hoping someone can help here.
I have a 2 tables called shedules and destinations.
The destination table consists mainly of just listed names of destinations throughout the world (and I do intend on having another field indicating the time zone in the form of a positive or negative figure dependant on zone).
Now the schedules part is the bit i want to try and make easier in that when you type in the departure location, the departure time, a duration (in time) and the arrival place on the Edit or Add page, the resultant arrival time is the local time for the arrival place (field updated automatically rather than filled manually).
I hope that makes sense.
Thanks,
Graham