Parent and child

Question

How to make a parent and child table?

Vijaya Kadiyala · Answer

Hi Basically you need to define PRIMARY KEY and FOREIGN KEY relationship to make two tables in PARENT-CHILD relationship. Thanks -- Vj http://dotnetvj.blogspot.com

Dipal Choksi · Answer

Create 2 tables with the primary key of the parent table set as foreign key of the child table (assuming 1-M parent-child relation) eg. Parent table: ParentID INT IDENTITY(1 1) ParentField1 varchar(50) ParentField2 int etc Child Table: ChildID INT IDENTITY(1 1) ParentID int ChildField1 int ChildField2 varchar(15) etc