Unanswered: Unsure on how to create a price list - excel or access
I have created a database which is based around ordering certain products.
Part of the order will involve a pricing system.
As the prices are not always for individual products I am unable to apply a price to each product in the tables I have. Some product are combined with others and then have a price to them.
The price list will change depending on the sales of the combinations or individual products so a product may be discontinued and if the product was within a combination of product a new one will be added and thus that will change the price.
Because of this I decided to create the price list in Excel as when it needs editing it can be. My problem is then getting this file onto a form and the user then having the ability to select one or more prices from the spreadsheet. Then the form will calculate the prices and add whatever discount etc but the totals will always go in my orders table along with the discount.
I have know you can have an unbound object with the excel sheet in that but I have got a little stuck as to how to make it able to select items within it.