How to insert rows dynamically

[jsgaggio]

How do I create rows from a view. I have 3 tables

1. dim_tasks contains a list of mandatory tasks.
2. dim_people are all of the people
3. Src_tasks contains the tasks assigned to a person.
If I join dim_task and dim_people and create Qry_People_Tasks I can get all of the tasks.

If I take Qry_people_Tasks and join it with the src_tasks table the results would return all tasks where a row existed in the src_tasks table or not. It would accomplish my objective - make sure as new tasks get added - the user gets assigned these rows. But I'm stuck - where do I go from here?

Joani

[Delerna]

Sorry, I am not sure what you are asking.

Are you saying Qry_people_Tasks is not returning
the people who don't have a task assigned to them
but you need it to ?

If so, then right click on the line joining the two tables and read carefully the three options that apply to the join.
Select the one that describes what you need.