Post reply

NEED HELP TO RESOLVE TABLE

  • March 29, 2006 at 8:39 am

    #168894

    This is where the education and or experience will have to come in because i think this question is one that might could go a couple of ways...

    One User can have One Company. ..... One Company can offer many Specialtys (ok)..

    When user is signing up they can choose from my UserTypes ..When the user selects the UserType that best descibes Them and them I then load DDL'S with the different Specialtys that .THAT specif UserType offers ( select SpecialtyName, SpecialtyCD from [Users.Specialty] WHERE [Users.UserTypeCD = @UserTypeCD]) <-----Just a test querry to let someone know what i am doing..

    Can someone please help me with pointing out to me if i should try to use something link i started for the [Users.UserTypeSpecialtyType] OR Can i tap into the [[Users.CompanySpecialty]] and use this table to resolve the many to many...

    Basically:  When a user is signing up they pick their usertype that descibes them... Then from that selection i present ( vis ddl )different specialtys that ..that Usertype offers.... Then when they are satisifed i insert the usertype into the users, company, and the [Users.CompanySpecialty] table... Then to mange the User I ( or they can)sign in their self ( Then as a defined Usertype ) can select * from [Users.Specialty] where [Users.CompanySpecialty] = @user-id

    Please note that i know my querry is wrong but it might help you help me.. ( Now say that ten time fast )

    i need suggestions for this one..

    I need to resolve these many to many tables...

    erik

    http://ConstructionSuperCenter.Com/Help/SoftWare/sql-table-Help.gif

    Dam again!

  • April 3, 2006 at 11:19 am

    #630482

    Your explanation is pretty confusing. I'm not sure what you are trying to do. After looking at the graphic of your table design, I think you have some design issues.  For example, why would a table with a primary key of UserID have a column in it called CompanyDescr?  Where is the list of specialties for each company?  Maybe post some sample data along with what you are trying to accomplish.

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply