how to create relational connection in SQL Server and MS-Access ?
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)