I have the table owners and the table stands, with PKs ownerID and standID respectively. They have a m-to-m relationship, so I want to link them with a linking table.

Am I correct in thinking that these tables do NOT need foreign keys from their respective other table? That is, the owners table does not need the foreign key, standID and the stands table doesn't need the ownerID foreign key, if my objective is to link the two through a linking table.

Yes.

-PatP

Thanks. This stuff is starting to sink in.

you been saying that for weeks

just how deep are you expecting it to sink?

Keep in mind that the natural densification process started long ago, with me. And, my temporal reference is geological time. So, "starting to sink in" can be a long, long process.