12:17AM VERY TIRED---nEED ADVISE/HELP

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 .........

Keith,

It's 1:03 AM where I am and I am beyond tired... I digress....

Your problem is the ONE table, should have been two tables right off the
bat. One train (one table), many passengers (another table). So this will
not be a quick and dirty answer. Do you have the time to correct the
tables? Then you could easily create a form/subform situation which would
completely satisfy your Users.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Keith" wrote in message
...
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 .........

I was afraid of that.......2:30am Thanks Gina

"Gina Whipp" wrote:

Keith,

It's 1:03 AM where I am and I am beyond tired... I digress....

Your problem is the ONE table, should have been two tables right off the
bat. One train (one table), many passengers (another table). So this will
not be a quick and dirty answer. Do you have the time to correct the
tables? Then you could easily create a form/subform situation which would
completely satisfy your Users.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Keith" wrote in message
...
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 .........

Glad to help... sorry it wasn't the answer you wanted!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Keith" wrote in message
...
I was afraid of that.......2:30am Thanks Gina

"Gina Whipp" wrote:

Keith,

It's 1:03 AM where I am and I am beyond tired... I digress....

Your problem is the ONE table, should have been two tables right off the
bat. One train (one table), many passengers (another table). So this
will
not be a quick and dirty answer. Do you have the time to correct the
tables? Then you could easily create a form/subform situation which
would
completely satisfy your Users.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Keith" wrote in message
...
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 .........