D
Dave Greene
I have a customer that needs a tool to create NTO's
(Notice to Owners) reports and track them. I am trying to
use Access 2002 to:
1. Tie together data from two existing tables, Projects &
Members, then add some record specific information.
2. Create a report using this information that will allow
the user to edit the info in report and also rerun/reprint
the report at a later time.
3. Create a new record of this information into another
table. (I think I need to use an insert into statement but
not sure.)
There is no existing relatoinship between the two tables.
The idea is that the user uses a form that uses two combo
boxes to select the member and project records. If there
is no record for a project, the user needs to enter one.
The user then adds some additional info like Date, Mail
Type, etc.
Once this information is put together, I need a way to
save the information into a table. Any ideas on how to do
this?
Thanks!
Dave
(Notice to Owners) reports and track them. I am trying to
use Access 2002 to:
1. Tie together data from two existing tables, Projects &
Members, then add some record specific information.
2. Create a report using this information that will allow
the user to edit the info in report and also rerun/reprint
the report at a later time.
3. Create a new record of this information into another
table. (I think I need to use an insert into statement but
not sure.)
There is no existing relatoinship between the two tables.
The idea is that the user uses a form that uses two combo
boxes to select the member and project records. If there
is no record for a project, the user needs to enter one.
The user then adds some additional info like Date, Mail
Type, etc.
Once this information is put together, I need a way to
save the information into a table. Any ideas on how to do
this?
Thanks!
Dave