[thelist] Access DB design troubles

burgan at iprimus.com.au burgan at iprimus.com.au
Thu Jul 17 10:07:46 CDT 2003


Hello,

I'm trying to design an Access DB that will hold customer details.
My problem is that I want to hold details of who referred each customer,
where each referred is a customer that is currently on the database.

I don't know how I go about doing this without duplicating information.

Here's my CUSTOMERS table.

---------
*UserID (autonumber)
FirstName
LastName
CompanyName
Address1
Address2
City
State
PostCode
Country
Phone
Fax
Email
Username
Password
ReferralID
---------

The last field 'ReferralID' I planned for the Data Type to be a number. I'm
stuck!! 

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?

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.

I'm totally lost, I'd appreciate as much help as possible.

Thanks
Tim

--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .




More information about the thelist mailing list