I am trying to create the following class and functionality

i have 2 tables

Products
ProdCode
ProdName

SupplierProducts
SupplierID
ProdCode

The product table is just a lookup to the details. A supplier can have many products. I want to get the details for a supplier including the product details.

What type of associaltion should i use. Some examples will be helpful.

Thanks

I assume that you have another table called Supplier to store the Supplier details and the SupplierProducts table is the join table between Supplier and Products.

If your SupplierProducts table is just going to have SupplierID and ProductCode you can use a many-to-many relationship between Supplier and Products table. If you want to have more columns in the join table you can then model this as a 2 one-to-many relationships (this will require you to model SupplierProducts as a entity as well)