Adding mulitple records from same form

[mikehorse]

Hi.
I've looked around the forum and can't find (or more likely don't understand) the answer, to my query;

I have a table called Tasks - Contains tasks names and other task details.
TaskID (PK)
TaskName
...
and a table call Steps - Each entry is a step(s) linked to a specific test

StepID
StepName
StepAction
TaskID (FK)

I want to add a button called 'Add Steps' to my Task Form, that will open my step form (a continuous form) and populate the task Id field for each step I need and upload to step table.

[ssanfu]

I am confused on your table structure.

Are three tables involved? Tasks, Steps and a junction table?

Is this true: "One Task can have many steps and one step can be associated with many Tasks"?

[mikehorse]

Hi

The table structure I have is a one to many relationship between Task and Steps. No linking table.

[ssanfu]

How do you decide/pick what Steps are needed for a Task?
Do you fill in the "StepName" and "StepAction" fields later?

[Missinglinq]

So why not simply add the Steps Form to the Tasks Form as a Subform? The TaskID will then be automatically passed to the Steps Form.

Linq ;0)>

[ssanfu]

@Linq

Doh!!!!!!

(I should engage brain before starting fingers....)