[thelist] Access DB design troubles

[Tab Alleman]

burgan at iprimus.com.au wrote:

> I want plan to use ASP to manage this DB. The user enters their
> details in an ASP page (including the name of who referred them), the
> DB is then searched for the referrers name and places their UserID
> into the new users ReferralID field. Will that work?

Yes.

> On 1 ASP page, will I be able to see the details of 1 user, plus ALL
> the details of the user that referred them just by knowing their
> ReferralID. 

Yes.

The design you planned will be fine..you'll be able to do what you want.