Links To Multiple Tables With Link In Linked Table

[KAndle]

OK let me try and make it simple. I have a database with a tables (manf, parts, store, sku) I use column 'idmanf' to links parts to manf. This work fine I can list parts & manf info together. I then created a 4th table called sku. I have linked it to parts & store.

I tried creating a 5th table to hold purchase dates and tie in the store, sku, item, & manf.

I buy the same things alot so I want to create this table to hold purchases & what they are and where they came from, etc. A query that will list the manf info with the part info as well as the store info with the sku, prices and dates purchased.

Any help in the right direction would be enough.

I think I am getting the WHERE statement wrong. I have links to three different tables in the 5th table and one of the tables in linked to one more table. How do I define that?