Hi experts. I got a small db in sql 2000 server that i imported it from access 2000 db.(6 tables). Unfortunetly i lost the reletionship between tables in this process! i wonder how i can add these table reltionsship back to sql server db and alos cascade delete/update to this sql server db ?
Furthermore, is there any way to view the table reltionshiip in sql server 2000 like access 2000?
I be happy if some one help me here since i am new to sql server and the whole db design.Thanks
This is a picture of my db reltionship: