Qns on global field & timetable

[tottijohn]

Global Field

I have a layout, A, using global fields to verify first before saving into the table. There is a 'New' button scripted to clear all gFields so that user can input new entry. There is another layout, B, with similar functions, sharing some gfields too, which the 'new' button script includes.

So saying two users are each using one layout. If the 'New' script is performed while layout B is ongoing, will it affects?

Have been building the database on a comp, no chance to try it on multiple comps. Need to know this before proceeding.

Timetable

Which is a good way to create a timetable? Its an optional to my current database but will be more efficient to the user if i can incorporate this.

It involves scheduling my buses. Each record involves an arrival and departure date & time of a group. Right now, i need to assign my bus to the timeslot, making it unavailable for that date and time only. With a total of eight buses, i may require to rent external buses if my own buses are fully unavailable. Hope someone can point me to the right path here.

[mr_vodka]

For Question 1, please see the link in my signature file for a write up by David Kachel on how global fields work.

For Question 2, take a look at this method by Ray Cologon

[tottijohn]

The Ray Cologon's method is really great! Almost flawless for my case. Thanks john