LEFT JOIN question

[tricard]

Good day all,

I have four tables that I am attempting to LEFT JOIN together in a
query:
tblPartNumber (PartNumberID is primary key autonumber)
tblPartNumberVendor (PartNumberVendorID is primary key autonumber)
tblPartNumberSupplier (PartNumberSupplierID is primary key autonumber)
tblPartNumberCost (PartNumberCostID is primary key autonumber)

The relationships are as follows:
tblPartNumber.PartNumberID --1-------many-->
tblPartNumberVendor.PartNumberID
tblPartNumberVendor.PartNumberVendorID--1------many-->tblPartNumberSupplier.PartNumberVendorID
tblPartNumberSupplier.PartNumberSupplierID--1---many-->tblPartNumberCost.PartNumberSupplierID

I attempted this SQL statement but was flagged for a syntax error:
SELECT tblPartNumber.fldPartNumber,
tblPartNumberVendor.fldPartNumberVendor,
tblPartNumberSupplier.fldPartNumberSupplier
FROM tblPartNumber LEFT JOIN tblPartNumberVendor ON
(tblPartNumber.PartNumberID = tblPartNumberVendor.PartNumberID)
LEFT JOIN tblPartNumberSupplier ON
(tblPartNumberVendor.PartNumberVendorID =
tblPartNumberSupplier.PartNumberVendorID)
LEFT JOIN tblPartNumberCost ON
(tblPartNumberSupplier.PartNumberSupplerID =
tblPartNumberCost.PartNumberSupplierID);

Should I change my relationships and have PartNumberID to be related
throughout all four tables?

Thanks for the help