input from form to a different table

[Chris]

Ok, so the way I am trying to set this up may not be the most practical. I
haven't had a need to use access for almost 5 years.

In the past I have had a paper log sheet to fill out. Due to time
differences in arrival time, I have broke down the log sheet into different
sections by using different tables. Each of these tables has its own short
form. On these tables/forms I have 3 of my 7 fields already filled in because
this information never changes from day to day. So after the form pulls the
information and all fields have been filled in, I am trying to get the
records to be saved into a different table, one which all of these broken
down tables will come back together in. I know i could just leave all this as
one table and have everyone just update it, but I am trying to make this
"logging for dummies" style.

So am I going about this a REALLY long way, or is it really as comlpicated
as I am making it seem.

Any help is appreciated.

 

[June7 via AccessMonster.com]

Hopefully, there is no need to save to another table. Queries and reports
should be able to produce the effect of one composite table. Not knowing the
complete structure of your project, not sure which query type would serve,
Union or Join. Unfortunately, there is no wizard to help you build Union
queries. Have to type them in SQL view of the query designer. See if you can
perform a join of these tables to get the effect you need. An alternative
would be to have one big table and several forms specialized for each section.
Each form would have boxes bound to only the particular fields needed.