Ok, so after re-doing the relationships to ensure I had it done correctly, and re-doing the reports, I came to remember that the filter in the join table grid edit is to SHOW Secondary Items already input, not show only Secondary Items as options. I knew that but didn't remember.
I think that I might have to generate two different Prices tables: Primary Prices, and Secondary Prices, then build my join table off of the Secondary Prices table.
I don't know why, but something rubs me the wrong way about doing it like that. It doesn't seem like the best way to accomplish the end goal.
There has got to be a way to have only the Prices table, which lists the Primary and Secondary items, then have the Join Table (Costs) only list the Secondary Items from the Prices table.
But it currently escapes me.
------------------------------
Andrew Fry
------------------------------
