I am working on a MS Access database to track the sales of a 3 Tier Multi-
level Marketing system.
I have created a table to track a new RepID and a SponsorID. I have created
a query that will show the Sponsor and all of their reps but I am not sure
how to show the reps that the second tier has sponsored.
Example:
RepID 0011 SponsorID 0010
RepID 0012 SponsorID 0010
RepID 0013 SponsorID 0010
The above is easy but I am not sure how to get:
RepID 0014 SponsorID 0013 and his SponsorID 0010
Does anyone have any idea of a good way to do this?
Thank you,
Brent
3  3740 
Brent,
It concept, it is a hierarchical data problem. Others here have solutions
different from the three I know about. Each solution to this problem has
its benefits and drawbacks. Study each one to decide which works best for
you.
Solution 1:
Single table joined to itself and modeling a one-to-many relationship
between a row in the table and other related rows in the same table.
Solution 2:
Two tables, one is the detailed information about each thing in the
hierarchy (sales representative in your case) and the other is a two column
list of primary keys from the first table that lists which thing in the
first table is related to the other and modeling a many-to-many relationship
between a row in the first table and another row in the first table.
Solution 3:
Two tables like Solution 2 but with as many columns as are needed in Table 2
to list each level of the hierarchy. This can make navigating the hierarchy
easier in some cases.
--
Alan Webb kn*******@SPAMh otmail.com
"It's not IT, it's IS"
"Brent Taylor via AccessMonster.c om" <fo***@nospam.A ccessMonster.co m> wrote
in message news:7e******** *************** *******@AccessM onster.com... I am working on a MS Access database to track the sales of a 3 Tier Multi-
level Marketing system.
I have created a table to track a new RepID and a SponsorID. I have
created
a query that will show the Sponsor and all of their reps but I am not sure
how to show the reps that the second tier has sponsored.
Example:
RepID 0011 SponsorID 0010
RepID 0012 SponsorID 0010
RepID 0013 SponsorID 0010
The above is easy but I am not sure how to get:
RepID 0014 SponsorID 0013 and his SponsorID 0010
Does anyone have any idea of a good way to do this?
Thank you,
Brent
Thank you for your response. I thought about the 3 items that you wrote but
I am not really sure how you mean to apply them.
Can you give me any further info?
Thank you.
--
Message posted via http://www.accessmonster.com
Brent,
I replied elsewhere that this is not a simple problem. There are software
companies that sell packages which will do what you want. If you have more
time than money then I suppose choosing to try and make something would be
worth it. But be aware that custom software development can be a
hair-pulling and frustrating experience for client and developer alike.
You've got to have the stomach and balls for it.
--
Alan Webb kn*******@SPAMh otmail.com
"It's not IT, it's IS"
"Brent Taylor via AccessMonster.c om" <fo***@AccessMo nster.com> wrote in
message news:57******** *************** *******@AccessM onster.com... Thank you for your response. I thought about the 3 items that you wrote
but
I am not really sure how you mean to apply them.
Can you give me any further info?
Thank you.
--
Message posted via http://www.accessmonster.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Heather Stovold |
last post by:
Wow - deciding to program in python sure requires a lot of decisions!
So far:
I've decided on python for the programming language.
I've decided on wxpython for the GUI....
I've decided on DrPython for the Editor....
I still need to decide on a database........ I've really only used Access,
and my SQL skills aren't that great. It would also need to be free....
|
by: Bobby |
last post by:
Hello everyone I have a question. The school I am working for is in
the beginning process of having a webpage that will direct students to
download there homework and be able to view there info like test
scores and etc(the homework and info page will reside on our
webservers at the school on the local intranet network). Now what I
need is a way for the students to go to a login page and when logging
in will be automatically directed to...
|
by: Jake Jessup |
last post by:
A client wants me to do a conversion from Access 2.0 (yeah, I know, unreal).
The problem is, she doesn't have the install disks and I haven't had a copy
of 2.0 in years.
If some kind should could kindly point me to a place where I might get a
copy, I would be grateful.
I'm willing to do a trade for it.
|
by: Tee |
last post by:
Hi,
I need some help here for DSN connection string.
I know it's not recommended to use DSN, even I dont like it as well ...
but for now, my situation is I am using a shared hosting. I do not have
write access to my web root folder, I have a folder specialy for database.
I am currently using access, it is just for testing purpose.
here's the info:
|
by: peshekeedweller |
last post by:
Using asp.net 1.1. vb.net 2003.
I am trying to connect to a remote sql server 2000 on a virtual machine
running windows 2000 server. I can connect through the server explorer in
visual studio, but cannot connect through code. I have done it before and
can not do it now; I don't know what changed. (I also cannot connect to
local Access database through code though I can from server explorer.)
The code is:
conn = New SqlConnection("data...
| | |
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to
communicate with a MySQL database table on a web server, from inside
of my company's Access-VBA application. I know VBA pretty well but
have never before needed to do this HTTP/XML/MySQL type functions.
|
by: Paul H |
last post by:
A typical chunk of code......
Set db = CurrentDb
Set rs = db.OpenRecordset("tblFoo")
<Do some stuff here>
'How much of the stuff below do I need?
'Do I need to close the recordset?
rs.Close
|
by: Alan Mailer |
last post by:
A project I'm working on is going to use VB6 as a front end. The back
end is going to be pre-existing MS Access 2002 database tables which
already have records in them *but do not have any AutoNumber* fields
in them.
Correct me if I'm wrong, but I'm assuming this means that I cannot now
alter these existing Access tables and change their primary key to an
"AutoNumber" type.
If I'm right about this, I need some suggestions as to the...
|
by: Mary |
last post by:
First of all, I want to thank all of you who post out here regularly. I
have learned so much over the last couple of years! During my 10 years
as a Cobol programmer, working with dozens of other programmers, when I
got stuck, I just had to walk over to the next cubicle to get help. Now
it's just me, which can get overwhelming and quite stressful at
times. So when I need help, I come to you guys. I don't usually even
have to post a message,...
|
by: nihad.nasim |
last post by:
Hi there,
I have a database in Access that I need on the web. The web page
should connect to the database and write records for certain tables
and view records for others. I want to know a reliable way of
connecting Access to a server. I am willing to switch to any version
of Access which might solve the problem. Which server would you
recommend and what are the advanatages and disadvantatges of the
server you propose? Please also inlcude...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
