the relationship is crteated by storing the product ID in the productFileProductID
in the products table, you may have the following record:
productID | ProductName etc...
22 | widget 1
to associate files in the productFiles table to the Widget 1 Product (ID 22) the records in the productFiles table would look like:
productFileID | productFileProductID | productFileFielName
1 | 22 | File 1
2 | 22 | File 2
3 | 22 | File 3
see the W3Schools page on SQL Joins for more details;
http://www.w3schools.com/sql/sql_join.asp


