金字塔委员会 [英] pyramid commission
问题描述
嘿伙计们，
我正在使用2007年访问权限。我对以下问题的解决方案不满意所以我希望你们其中一个人有一个更好的主意。我的解决方案需要使用多个值的字段，我知道联合查询和多值字段彼此不能相处得很好。所以...
这是我正在使用的典型数据：
人A
人B （人A的新人）
人C （人A的新人）
人D （人员C的招募）
人E （人才招募） D）
（人A，B，C，D和E是表中的所有记录集）
这基本上是你的典型的金字塔计划。让我们说PersonA招募PersonB和PersonC。 PersonA根据PersonB& amp; PersonC卖出并且他们的新兵卖的比例较低。
现在，如果一个人招募10个人，他们就会成为经理。我创建了一个表格，其中包含招募人的字段。和经理为每个人。让我们假设PersonA是一名经理。这在当前情况下工作正常。人D'的招募者字段将读取PersonC和经理字段。字段会读取PersonA。 现在这里是我的主要问题。让我们现在假设PersonC刚刚招募了10个人，现在是经理。在这种情况下，PersonD'的字段是招募的。会读到PersonC和他们的经理。字段也将读取PersonC。现在没有数据可以将PersonD和PersonA链接在一起，即使PersonA仍然收到PersonD销售的佣金。
看看我的问题在哪里？我可以创建另一个字段并将PersonA放在该字段中但是如果PersonE要成为管理员，我将不得不创建一个新字段AGAIN。每当其中一个人的新兵成为经理时，就会发生这种情况。
我能想到的唯一一件事就是让经理人领域成为一个多值领域，这样我才能存储超过一位经理。我的想法是，必须有其他人不得不处理这个问题（那里有很多金字塔计划）。有人可以给我一个简单有效的方法来跟踪新员工，经理和基地经理的想法吗？
i会很快回复b / c时间是完成这个的一个因素系统。我们曾经使用excel来处理这些数据，但我们不得不解雇这样做的人。我们需要让这个系统在大约一周的时间内完成。
(Person A,B,C,D,&E are all recordsets in a table)
this is basically your typical pyramid scheme. let''s say PersonA recruits PersonB and PersonC. PersonA receives commission based on what PersonB & PersonC sells and a lower percentage commission of what their recruit(s) sells.
now, if a person recruits 10 ppl, they become a manager. i have created a table with fields for "recruited by" and "manager" for each person. let''s assume PersonA is a manager. this works fine under this current scenario. Person D''s "recruited by" field would read PersonC and the "manager" field would read PersonA. now here''s my main problem. let''s now assume that PersonC has just recruited 10 people and is now a manager. under this scenario, PersonD''s field for "recruited by" would read PersonC and their "manager" field also will read PersonC. now there is no data to link PersonD and PersonA together even though PersonA still receives commission on PersonD''s sales.
see where my problem is? i could create another field and place PersonA in that field but if PersonE were to become a manager, i''d have to create a new field AGAIN. this would occur everytime one of these person''s recruits became a manager.
the only thing i can think of is to make the manager field a multivalued field so i can store more than one manager. my thinking is there has to have been someone else who has had to deal with this before (there are plenty of pyramid schemes out there). could someone give me any ideas for a simple and efficient way of tracking recruits, managers, and the base manager?
i would appreciate a quick reply b/c time is a factor in completing this system. we used to use excel to crunch this data but we had to fire the person who did this. we need to have this system going in about a week''s time.
推荐答案
那里。
这个是一个使用递归代码的经典案例。
你需要编写一个向下扫描树的VBA函数（让我们使用这个普遍接受的（至少编程）单词而不是金字塔）预定义节点（在你的情况下是人ID）。
下面以伪代码描述逻辑。
Hi, there.
This is a classical case to use recursive code.
You need to write a VBA function scanning down the tree (let use this commonly accepted (in programming at least) word instead of "pyramid") from a predefined node (person ID in your case).
The logic is described below in pseudocode.
这正是我的意思正在寻找!!你让我今天很开心。非常感谢你！
that''s exactly what i was looking for!! you just made my day. thank you so much!
这正是我所寻找的！你让我今天很开心。非常感谢！
that''s exactly what i was looking for!! you just made my day. thank you so much!
欢迎您。
祝您好运。
You are welcome.
Good luck.
这篇关于金字塔委员会的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
