访问规则表/方法有谁听说过吗？ [英] Rules Table/Method in Access, has anyone heard of it?
问题描述
我们有5000个产品，分别有价格和200个客户，每个产品都可以有不同的价格。我们需要一些允许销售团队改变个人客户或产品或范围/类别的价格，而不会影响其他客户的其他价格。
We have 5000 Products all with separate prices and 200 customers who could all have different prices for each of these products. We need some way of allowing the sales team to change prices for individual customers or products or ranges/categories without affecting the rest of the prices for the other customers.
现在这是通过复制和粘贴价格表，进行手动更改并将新价格表导入类别来完成的。这不是我们想要的。
Right now this is done by copy and pasting a price list, making manual changes and importing the new price list as a category. This is not what we want.
我已经被告知有关通过在访问中存储一组价格，然后是规则表来实现同样的事情的方法应用基于以下信息的规则：
I have been told about a method of achieving the same thing simply by having a set of prices stored in access and then a rules table that applies a rule based on information such as:
- 客户
- 产品
- 类别
- 价格
- 百分比
- Customer
- Product
- Category
- Price
- Percentage
这将允许我们为每个价格变动存储一行信息，而不是整个价格清单只是为了进行一个修改。
This would allow us to store one line of information for each price change instead of an entire list of prices just to make one amendment.
基本上我在问任何人都曾经听说过这种方法，哪里可以找到更多有关此方法的信息以及如何运作/如何应用？
Basically I am asking if anyone has ever heard of this method and where we can find more information about this method and how it works/how to apply it?
提前感谢
Bob P
Thanks in advance, Bob P
推荐答案
您需要一张基本上每个客户的特价单的表格。该表将由客户编号，零件编号和价格组成。只有与一般价格表不同的价格才会出现在这个表格中。
You need a table which is basically each customer's special price list. The table would consist of a customer number, a part number and a price. Only prices which differ from the general price list should appear in this table.
在找出给定客户的零件价格方面，首先程序会检查在此表中查看是否有给定部分和客户的条目。如果没有找到记录，则使用一般价格表。
In terms of finding what a part's price should be for a given customer, first the program would check in this table to see whether there is an entry for the given part and customer. If no record is found, the general price list is used.
这篇关于访问规则表/方法有谁听说过吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
