how i can make the relation ship in MS SQL ?
That is such an open ended question that a short answer is impossible. Please provide more details. What are the tables you want to link and how are they related?
MS sql server follow the RDBMS & Cods concepts.
You can not enforce having row in child table by using constraints. (because you first insert row in parent table and only then in child table- its not one operation but 2, even though it most possibly one transaction)
But you can use stored procedure to insert data and you can do validation inside a procedure.
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.