K
Keith
I hope to explain this right... need to save data from 2 forms at the same
time…
two tables
table one | table two
Table one has 4 data fields + auto number (key), Table Two has 6 data fields
+ long int field. one to many relationship connected to auto num (key) in
table one
I have two forms to enter data.
form 1 for data entry into table one
form 2 for data entry into table two
The issue I am having is two fold,
Form 1 when used should allow the user to select data that is repetitive on
each record entered from form 2, or in other words form 1 selections stay
selected and saved with each entry from form 2.
Here is an example: Form 1, data tells us the date the information entered
on form 2 was gathered, it tells us if the train spotter was working inbound
trains or outbound trains. It tells us what train line the data was gathered
at (north south east west) and what station on the line the data was gathered
at.
Date | inbound/outbound | Train Line | Station
Form 2 is the data that goes with form 1.
Example form 2
VEH # | Route | Var | BL # | Destination | # of passengers | Time
What I want and what the user wants to happen is.
1.) User selects the data options on form1, then press the already made
button that opens form 2.
2. The user will then enter data on form 2 and stays on form 2 not going
back to form 1 until they enter another spoters data, their may be 50 entries
of all form 2 fields. They do not want to go back to form one for each record
it does not change that often.
The selected data on form 1 needs to be saved into table one, each time the
user complets a record in form 2 data. I hope this makes sense….
In word form
The employee worked “1/10/2009â€, he worked the “inbound trains†on the “west
line†at station “W-5†and here on form 2 is what he reported that day.
I need to make sure each time data is entered and saved on form 2 that the
preselected data of form 1 is also saved with that record. So a complete
record contains all information from both forms.
Each time a new line of data is entered into form 2, form 1 pre-selected
data needs to be saved to table 1.
How do I do this? How do I make form 1 data save with the saving of the data
from form 2
Complete records should look something like this on a query
1/23/2009 | IN | west | W-5 | (form 2 data begin) A23 | g5 | ATL | 35 | 9:43
1/23/2009 | IN | west | W-5 | A24 | 3e | BOS | 22 | 10:02
1/23/2009 | IN | west | W-5 | Y45 | fg | LAX | 45 | 10:26
1/23/2009 | IN | west | W-5 | e12 | bb | NOL | 31 | 11:05
1/23/2009 | IN | west | W-5 | h13 | bb | NOL | 15 | 11:05
1/23/2009 | IN | west | W-5 | t12 | bb | NOL | 8 | 11:05
Please notice the dup "times" above, this shows us the inbound train at
11:05 had 3 cars one with 31 passengers one car with 15 one car with 8
Pleas advise any help
Keith
time…
two tables
table one | table two
Table one has 4 data fields + auto number (key), Table Two has 6 data fields
+ long int field. one to many relationship connected to auto num (key) in
table one
I have two forms to enter data.
form 1 for data entry into table one
form 2 for data entry into table two
The issue I am having is two fold,
Form 1 when used should allow the user to select data that is repetitive on
each record entered from form 2, or in other words form 1 selections stay
selected and saved with each entry from form 2.
Here is an example: Form 1, data tells us the date the information entered
on form 2 was gathered, it tells us if the train spotter was working inbound
trains or outbound trains. It tells us what train line the data was gathered
at (north south east west) and what station on the line the data was gathered
at.
Date | inbound/outbound | Train Line | Station
Form 2 is the data that goes with form 1.
Example form 2
VEH # | Route | Var | BL # | Destination | # of passengers | Time
What I want and what the user wants to happen is.
1.) User selects the data options on form1, then press the already made
button that opens form 2.
2. The user will then enter data on form 2 and stays on form 2 not going
back to form 1 until they enter another spoters data, their may be 50 entries
of all form 2 fields. They do not want to go back to form one for each record
it does not change that often.
The selected data on form 1 needs to be saved into table one, each time the
user complets a record in form 2 data. I hope this makes sense….
In word form
The employee worked “1/10/2009â€, he worked the “inbound trains†on the “west
line†at station “W-5†and here on form 2 is what he reported that day.
I need to make sure each time data is entered and saved on form 2 that the
preselected data of form 1 is also saved with that record. So a complete
record contains all information from both forms.
Each time a new line of data is entered into form 2, form 1 pre-selected
data needs to be saved to table 1.
How do I do this? How do I make form 1 data save with the saving of the data
from form 2
Complete records should look something like this on a query
1/23/2009 | IN | west | W-5 | (form 2 data begin) A23 | g5 | ATL | 35 | 9:43
1/23/2009 | IN | west | W-5 | A24 | 3e | BOS | 22 | 10:02
1/23/2009 | IN | west | W-5 | Y45 | fg | LAX | 45 | 10:26
1/23/2009 | IN | west | W-5 | e12 | bb | NOL | 31 | 11:05
1/23/2009 | IN | west | W-5 | h13 | bb | NOL | 15 | 11:05
1/23/2009 | IN | west | W-5 | t12 | bb | NOL | 8 | 11:05
Please notice the dup "times" above, this shows us the inbound train at
11:05 had 3 cars one with 31 passengers one car with 15 one car with 8
Pleas advise any help
Keith