relationship in SQL (.NET)?

A

ApurvA

New member
JAI MATADI .. .

hello i want to make RELATIONSHIP between Table1 and Table2 .. in in built SQL SERVER in .NET 2010 ..

i dont want to make relationship through coding .. i want in a simple way only like we make in MS ACCESS ..

here is my method how i want to make ,. ..

-----------------------------------------------------------------
Table1
---------------
(primary key)pid - int
personame - varchar
paddress - varchar
-----------------------------------------------------------------

-----------------------------------------------------------------
Table2
---------------
(primary key)id - int
productname - varchar
prdoctid - id
-----------------------------------------------------------------

now what i want is to make a relationship between Table1(id) and Table2(pid) ..

i have tried by writing in Table1's id , pname and etc .. and wanna show that ID of Table2's pid .. BUT M NOT ABLE TO SEE IT . .

please tell me how to do that .. again not through the code .. just the simple way like we make in ACCESS ..

thank you 4 yor support . .
 
Back
Top