thank you DavidBurrows it is working fine.

Eg.

Table_main

sno no

1 12313

2 98894

Table_details

Sno Item date

1 TV 3/1/03

1 Fridge 3/1/03

2 Car 3/3/01

2 Tape 4/4/01

i want result like

Sno no...

i have checked cascaded updates and deletes under cascaded inserts and updates by going the properties of the relationships in the data diagrams..is it not enough?

thank u anty..

there is one more problem..

while doing replication time it failed in error details..

it is showing login falied for sa.but both servers are using one another account for...