Sorry, Mary-Ann, but without the code I can't see what's wrong. Unless you aren't comparing the revision field in the product and component tables?

....
WHERE product.revision = component.revision ....

HTH
Barbara

>Hi Barbara and Erik,
>I'm so sorry, I see what I was doing wrong now. (It was what you asked me to check Barbara, about if the numbers are characters you need to put them in quotes...Good God, how stupid of me...a complete oversight.) If you could be so kind as to help me with a "Join" question now...I can't seem to get different results no matter which Join I use. I have a "primary" table with one record for each product and a second table with components for the formulas. Each time the product formula changes, a new set of components is added and the "revision" field is incremented. When I try to do a view for a particular revision number, it gives me ALL of the records in the components table (components for all revisions) and the primary table lists a record for each component, but with the single correct revision number. I have changed the join condition to EVERY one available and the results are the same. What am I doing wrong now?