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
Solved

Infopath

Posted on 2011-02-16
2
215 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
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

The password reset disk is often mentioned as the best solution to deal with the lost Windows password problem. In Windows 2008, 7, Vista and XP, a password reset disk can be easily created. But besides Windows 7/Vista/XP, Windows Server 2008 and ot…
Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

839 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