Copying id's to a junction table based on criteria

[mary]

Here's what I'm trying to do:

I have a table that contains a list of tasks. If the checkbox =yes, then I'd like to copy those id's to a junction table. I can get 1 record to copy, but not all. I was using a macro with Set Value. ( I also tried an append query, but it didn't work as expected. Both forms (the one based on the task list, and the one based on the projects and tasks needed for the project, are on a tabbed spreadsheet.

This is a project database where at the beginning of a project I'd like to be able to choose what tasks are needed for a particular project.

I'd really appreciate any help. It's so hard to communicate what I'm trying to do!!

Thanks,
Mary

 

[mary]

I wanted to clarify that the append query is working, but I want the append to be only for the checked records for that project.

I checked that the joins seem to be correct for the junction table:

tblTaskList
idTask (PK)
TaskDesc
TaskYesNo

tblTaskDetail
idTaskDetail (PK)
idTask (FK)
idProject (FK)

tblProject
idProject (PK)
idTaskDetail (FK)

The append query puts the records in the table, but I only want them to go into the table for that project, and only if the yes-no field =yes.

Hope that helped to clarify!

 

[mary]

Is there anything I can do to make my question more clear or can you point me in a direction for more research?

Thanks,
Mary

 

[boblarson]

Normally for the junction table you would use one or two combo boxes to accomplish this on a subform. The main form would likely be the Project and then the Task Detail would be the subform and by doing so it would automatically (if linked on project ID) put the project ID into the task detail table and then you would use a combo to select the task and that ID would be stored as the record source of that combo.

 

[mary]

Thanks, Bob. I hadn't thought of doing it that way. I was hoping to see the list of choices on the left, and have the id populate the subform on the right.

The way you described is how I have it set up with project being the main form and task being a subform.

I really appreciate your input and help!!

Mary