Solved

Infopath

Posted on 2011-02-16
2
218 Views
Last Modified: 2012-05-11
Hi, I have been given the task of designing a info path solution to track referrals.
I get entered into the system I get a I'd.
If I refer somebody else my ref feral I'd gets place in the refferedby field. But I need to track one level down to give credit. So if I refer somebody and they refer somebody then I get credit and they get credit for that referral.

Client A refers client B
Client B refers client C.

Client B gets credit for Client C
Client A gets credit for client C because it is one level down. How can I  track one level down. It is easy to track who I reffered,but harder to track who I reffered,reffered
0
Comment
Question by:tuckcorp
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 9

Expert Comment

by:expert_tanmay
ID: 34914099
R u looking for a code? You have to have a database structure as follows

A->B
A->D
B->C
B->E
B->F
C->G
D->H

The above table demonstrates a tree structure. To read the structure you have to write a code similar to computer's folder structure. The algorithm is called recursive algorithm.

Cheers..
0
 
LVL 28

Accepted Solution

by:
clayfox earned 500 total points
ID: 34915672
From a solution design stand point your question does not relate to InfoPath at all.

InfoPath is the application which lays out the form that will be used to enter and communicate the data.  Your questions really is about reporting and how you analyze the data once it is collected.

You need a database first off. To store all of this information.  Contact information, billing information, etc. if these already exist you could use them in the form as lookups.

This particular data you really just need

ID, PersonRefering, PersonRefered, DateEntered, ReferalType, Paid, ... whatever.

You would build a form that is simple and easy for this to be recorded and saved to the database.

Then you would create a report or spreadsheet which connects to the data and does the report that shows the first leevel and then looks up the person who referred the personrefering and also does a calculation to show the payout amount etc.  Then when it is time to make payments every week someone would click on the report. Could even import into Quickbooks or your accounting system.

You should use SQL for your database then you can use Sql Reporting Service for hosting the report.

Hope that gives you an idea of the scope and building blocks.
0

Featured Post

Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had a hard drive that you can't boot into, but need to change the registry? Here is the solution! This article guides you through accessing and editing a registry of a non-primary drive. To read registry information on a non-prim…
Citrix XenApp, Internet Explorer 11 set to Enterprise Mode and using central hosted sites.xml file.
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question