J
JDA
Hi,
I am designing a database in Access 2000 that keeps track of ontime
performance for passenger trains operating in Canada. The database has
several tables (of course). The primary data entry form is a form/subform,
with the parent being the date of train operation, and the subform being a
table that holds records containing the trains operated that day and how they
performed. Another table contains information about the schedules of these
trains; I want the user to select a train, and then access to "fill in" the
default values for other fields in that record i.e. when I type or select
"27" from the dropdown menu (lookup to other table), Access enters the
scheduled departure and arrival times from the other table in to the related
fields in the train record table. The user could then modify these values
for that record if required...am I making sense?
In practice, far more trains are on time than late, so being able to do this
will significantly reduce the amount of keystroking required to enter the
data The user simply has to enter the train ID, and if the train was ontime,
the record will be generated without having to enter 10 more fields of data...
Thanks in advance for any help,
JDA
I am designing a database in Access 2000 that keeps track of ontime
performance for passenger trains operating in Canada. The database has
several tables (of course). The primary data entry form is a form/subform,
with the parent being the date of train operation, and the subform being a
table that holds records containing the trains operated that day and how they
performed. Another table contains information about the schedules of these
trains; I want the user to select a train, and then access to "fill in" the
default values for other fields in that record i.e. when I type or select
"27" from the dropdown menu (lookup to other table), Access enters the
scheduled departure and arrival times from the other table in to the related
fields in the train record table. The user could then modify these values
for that record if required...am I making sense?
In practice, far more trains are on time than late, so being able to do this
will significantly reduce the amount of keystroking required to enter the
data The user simply has to enter the train ID, and if the train was ontime,
the record will be generated without having to enter 10 more fields of data...
Thanks in advance for any help,
JDA