2. I would appreciate some guidance on the following. I have a Customer Table, Product Table and Special Prices Table. The Special Prices will contain Special Prices for specific Customers for Specific products. So the structure of the Special Prices table , will contain 3 fields, Cus_Num, Prod_Num and Spec_price. I will want two forms, One where the Main Key will be the Customer , and I will need to see all the Special prices by Product for that customer. I also will need a screen which shows a Product Code, and all the customers who have a special price for that product. Both of these tables will be Maintenance and View tables.

Whats the best way to set up the Special prices table. In one case, it can be viewed as l  a child table to the Customer, in the other as a Child table to the Product file