I have two related tables that I want to update via forms on two CF pages. The first page asks the user to select a 'week number' from a drop list. Once the week number is chosen, the user clicks 'Submit' and CF runs an action page that updates the week table and and MySQL autoincrements an ID for that entry.
A CFLocation tag at the end of the action page directs the user to the next form page, which asks for the tasks created during the selected week. On this page the user simply chooses a category from a drop list field and in a text field types the work completed. A 'Submit' button enters that data as well. But I need to relate the 'week table' entry to the 'task' table entry.
My question is this: I need to take the ID assigned from the 'week number' table (period_id) and set it up so that it inserts into the corresponding field in the 'Task' table (also period_id). How do I go about doing that?
A CFLocation tag at the end of the action page directs the user to the next form page, which asks for the tasks created during the selected week. On this page the user simply chooses a category from a drop list field and in a text field types the work completed. A 'Submit' button enters that data as well. But I need to relate the 'week table' entry to the 'task' table entry.
My question is this: I need to take the ID assigned from the 'week number' table (period_id) and set it up so that it inserts into the corresponding field in the 'Task' table (also period_id). How do I go about doing that?