I am in the midst of laying out the structure for a database that revolves
around a multi level marketing strategy similar to that of "All
Advantage's". When Users sign up, they are given a User # in the UserInfo
Table, and then in a related table, the UserLevel table, that same user# is
associated with the User they signed up under.
The difficulty I think I might have is that in the UserLevel Table, the
user# exists twice, once as the primary key (the user), and again to
reference whom that user signed up under. The user's are related to one
another. as an example, If one of you signed up under me (because I referred
you to the service), i could have User # 1, and you are User #2, In one
table, User#1 and User#2 are in seperate fields, but exist in the same
table. How can i use two different fields in the same table to reference
back to the UserInfo table? Is it possible to have two fields of one table
referring back to a single field in another table?