Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
purisqlserver
Yak Posting Veteran
73 Posts |
 Posted - 2004-04-27 : 14:56:40
|
| Hi,we are developing a asset management package.I have three tables Location,Sub_Location,Asset_Details.Location has Loc_Id,Location_name,Location_desc,Sub_location has sub_locid,subloc_name,loc_id(fk),Asset_details has Asset_Id,Loc_Id,Asset_Name.The requirement is to have a tree view on the left menu as follows:Location Assetor Location Sublocation Asset1 asset2Whts is the best table design for this?Thanx |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
|
|
|
|
|
Tree view