Qualified Manufacturer table relationships

I’m not familiar with tables used for qualified manufacturer. From looking at the DB fields in technical help I think I need to link the Part table to the PartXrefMfg table which then links to the Manufacturer table.

I believe for every 1 row in the part table we can have many rows in the PartXrefMfg table, and for every 1 row in the PartXrefMfg table we will have 1 row in the Manufacturer table.

Am I on the right track? Just want to make sure I have my head wrapped around the table relationships before I try to create a BAQ…