how to create relational connection ?

[S.Ravi]

how to create relational connection in SQL Server and MS-Access ?

[debasisdas]

You need to create foreign keys for that .

[antonyfernando]

you need to create foreign key in the relational table. you can make relational connection when you are creating a table or even useing alter table statement
exp
altertable table_name
add foreign key(column_name)

[debasisdas]

altertable table_name add foreign key(column_name)

You need to specify to which column of which table you want to refer in the foreign key.