>
> CREATE TABLE dbo.Emp
> (
> EmpID int PRIMARY KEY,
> EmpName varchar(30),
> MgrID int FOREIGN KEY REFERENCES Emp(EmpID)
> )
> GO
I do this to a depth of 5 with:
CREATE TABLE AdCategory
(
AdCategoryID integer auto_increment Primary Key NOT
NULL,
AdCategoryIID Integer,
ParentAdCategoryID integer references AdCategory,
CreateDateTime DateTime,
Name VarChar(50)
)
You can see it in action at:
http://67.124.145.42/cfusion/Examples/ThinArray/FiveSelectsRelatedMySQL/
Select Automotive---> Cars, SUVs, Trucks, Vans... ---> whatever
to get the most depth.
there are 1295 records in the db
HTH
Dick
"In times like these, it helps to recall that
there have always been times like these."
- Paul Harvey -
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
