hello to all,
I am using MS SQL 2005. I have 3 tables, COLLAGE, USER, STUDENT
I am providing username & password to collage as well as students.
I wanted to assign Foreign Key to 'username' in both tables College & Student.
i have done,
1. right click on username (college table)
2. click relationsheeps
3.Assign foreign key.
but when I am inserting record, It gives me error that,
Conflict in inserting data.
I don't know how to insert data, means it i insert username in user table, will it automatically pasted in college table or not?
Thank you in advance!