Form needs to update two tables then ...


J

JR

I have one form and two tables that I am working with.

tbl_Tasks: with an auto number key and a list of tasks

and Hours: with its own auto number key and a list of tasks that each
employee works on. The tasks that the employee works on is selected (on a
form) from tbl_Tasks -- OR -- gets added to the table by using a combo box in
a form, frm_hrs.

I need to find a way to get the form (frm_hrs) to update tbl_tasks with any
new tasks added in the combo box. I can not figure out how to make this
happen.

There does not seem to be a problem updating tbl_hrs with the information
EXCEPT that the task number (ID) for a newly entered task doesn't update
(because tbl_tasks hasn't generated a new auto-number for the new task which
hasn't been added to it).

Could use some help to make this happen.

Thanks!
 
Ad

Advertisements

B

Banana

JR said:
I have one form and two tables that I am working with.

tbl_Tasks: with an auto number key and a list of tasks

and Hours: with its own auto number key and a list of tasks that each
employee works on. The tasks that the employee works on is selected (on a
form) from tbl_Tasks -- OR -- gets added to the table by using a combo box in
a form, frm_hrs.

I need to find a way to get the form (frm_hrs) to update tbl_tasks with any
new tasks added in the combo box. I can not figure out how to make this
happen.

There does not seem to be a problem updating tbl_hrs with the information
EXCEPT that the task number (ID) for a newly entered task doesn't update
(because tbl_tasks hasn't generated a new auto-number for the new task which
hasn't been added to it).

Could use some help to make this happen.

Thanks!

Normally, you would do this with a form-subform, each bound to their own
table (e.g. tblTask for the form and tblHours for the subform for
instance) with the subform's link filled in to automatically filter the
records. This will be far simpler than trying to update two tables on
one form, which is theoretically possible but a PITA & time blackhole.
BTW, you can make the subform look as if it's a part of the form so the
user doesn't even know there's a subform at all on the form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top