how to create relational connection ?

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

You need to create foreign keys for that .

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)

[QUOTE=antonyfernando;29121]
altertable table_name add foreign key(column_name)[/QUOTE]

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