K
Keith
single table db.
table= track trains
fields= date, inbound/outbound, Line, station, passengers, time, car #,
destination
the fields date,inboun/outbou, line and station need only entered one time
and then the fields passengers, time, car#, destination, are entered many
many times.
In other words to enter data fast and not have to select the date,
inboun/outboun, the line, the station for each train tracked in the other
fields i.e. passengers and car # etc.. the fields date,inboun/outbou, line
and station values will be the same for say 50 trains untill the spotters
move to another line or station.
I have a form with the fields date,inboun/outbou, line and station and a
button that opens another form that contains the other fields to enter the
non-repetetive data like # of passengers.
My problem is when records are to be entered the user selects the date, then
selects the listbox inbound or outbound, then cascading boxes selecting the
train line and finaly the station the next information to be entered was
gathered at.
At this point the user clicks a button and another form opens with the
fields passengers, time, car #, destination.
I want the user to be able to stay in this form entering the fields
passengers, time, car #, destination over and over quickly without having to
referr back to the first form and select those fields each time. so when the
user enters the last field data the complete data is saved to the table in
other words the first form data needs saved on the same line in the table.
I'm tired I hope this makes sense....
The way its working now the first form data is saved in the table as a
different record. I need the first form dats to be saved with each set of
dats from the second form. Ienter the first form data once I go to the second
form and enter data and each time i finish I need my table to list example
below.
10/11/2009 | INBOUND | WESTLINE | STATION1 | 32(Passengers) | 234C (Car #)
| 13:44 (time).
What I am getting is
10/11/2009 | INBOUND | WESTLINE | STATION1
| | |
|32(Passengers) | 234C (Car #)
Seprate records??????
How do I get the first form data to save with each completed entey of second
form data?
Thank you in advance just for reading this .........
table= track trains
fields= date, inbound/outbound, Line, station, passengers, time, car #,
destination
the fields date,inboun/outbou, line and station need only entered one time
and then the fields passengers, time, car#, destination, are entered many
many times.
In other words to enter data fast and not have to select the date,
inboun/outboun, the line, the station for each train tracked in the other
fields i.e. passengers and car # etc.. the fields date,inboun/outbou, line
and station values will be the same for say 50 trains untill the spotters
move to another line or station.
I have a form with the fields date,inboun/outbou, line and station and a
button that opens another form that contains the other fields to enter the
non-repetetive data like # of passengers.
My problem is when records are to be entered the user selects the date, then
selects the listbox inbound or outbound, then cascading boxes selecting the
train line and finaly the station the next information to be entered was
gathered at.
At this point the user clicks a button and another form opens with the
fields passengers, time, car #, destination.
I want the user to be able to stay in this form entering the fields
passengers, time, car #, destination over and over quickly without having to
referr back to the first form and select those fields each time. so when the
user enters the last field data the complete data is saved to the table in
other words the first form data needs saved on the same line in the table.
I'm tired I hope this makes sense....
The way its working now the first form data is saved in the table as a
different record. I need the first form dats to be saved with each set of
dats from the second form. Ienter the first form data once I go to the second
form and enter data and each time i finish I need my table to list example
below.
10/11/2009 | INBOUND | WESTLINE | STATION1 | 32(Passengers) | 234C (Car #)
| 13:44 (time).
What I am getting is
10/11/2009 | INBOUND | WESTLINE | STATION1
| | |
|32(Passengers) | 234C (Car #)
Seprate records??????
How do I get the first form data to save with each completed entey of second
form data?
Thank you in advance just for reading this .........