I have hit a road block. I have created a "Front End" data entry DB. The user will select a "Goal" from an unbound list box linked to tblGoal in another Main_DB. The user will then enter into an unbound text box ways that they will "meet" [Action] the Goal selected.
I have successfully been able to get the list box to select from the goal table.
But I am not sure how I would write an INSERT INTO statement to place the "Action" into tblAction(in Main_DB). The "Action" must be linked to the goalID selected.
Can anyone offer some assistance?
Thank you
I have successfully been able to get the list box to select from the goal table.
But I am not sure how I would write an INSERT INTO statement to place the "Action" into tblAction(in Main_DB). The "Action" must be linked to the goalID selected.
Can anyone offer some assistance?
Thank you
