Hi All,
Apologies for what may seem a simple question. I've done a fair bit of searching online but can't find the right question to ask to return the answer I'm looking for so thought it best i just ask on here.
I'm just playing around with a variant of the Northwind sample template database and am looking to insert customer discount into the customer details form (for those that know the template)
The customer discount varies for each customer and each product, so I'm thinking I'll need to create a new table which is linked to both the customer and product table and come up with the following fields;
Customer ID - from Customer table
Company - from Customer table
Product ID - from Product table
Product Name - from Product table
Product Code - from Product table
Standard Cost - from Product table
List Price - from Product table
Discount % - new field
Discount Price - new field
Now that could be completely the wrong way of going about it.
The end goal is to have a sub form underneath the Customer Details form which will display every product in a list along with all the information stated in the fields above.
Apologies if I haven't made my question clear but hopefully it's given a brief overview and if you have any questions then you can just ask me.