relationships with Sql Server

[chefdaveross]

heres a basic newb question:

How do I create a basic table join in sql.
I would like to perform a basic 1 to many rlationships in which I can choose a category on my item table.

From there I would like to create a combobox to select the category.

I would appreciate any web resources on how i can create relationships.
Ihave been searching all week but i can find one that suits my needs.

Thanks

 

[HiTechCoach]

I am confused on exactly what you want.

1) You you want to create a join in a query?

or

2) do you want to define a relationship in the database design?


If #1: How are you creating the SQL for the query?

If # 2: Have you looks at the SQL server Books on line?

 

[chefdaveross]

Thanks for the response,

I want to define a relationship in the database design

do I do that through table diagram?

seems that when i try to do the data is mismatched or im doing something wrong.

I need sort of o push to get going here.

I will make sure to study the books online on this subject.

Thanks

 

[SQL_Hell]

Hi,

Not sure if hitech coach is coming back to this thread or not, but in the meantime I will point you in the right direction....

Look up:

Alter Table

and

Add constraint

In books online and let me know what you've figured out yourself and whether you need additional help