IT WORKS!
plog ... My left join is probably in error. I thought it would attach my data from the two tables together.
I've tried linking the tables in the relationship, renamed the ID fields to unique names that both table had and a bunch other ideas.
I've followed your step exactly. It works...