CREATE TABLE dbo.ALineOfBusiness (ALOBKey INT IDENTITY,RecordID INT,AttorneyKey INT,
CONSTRAINT PK_ALineOfBusiness PRIMARY KEY (ALOBKey)
)

CREATE TABLE dbo.ALineOfBusiness_lobkey
(
sno int identity(1,1) primary key,
ALOBKey int ,
AttorneyKey int,
lobkey INT,
)

ALTER TABLE ALineOfBusiness_lobkey
ADD FOREIGN KEY (ALOBKey) REFERENCES ALineOfBusiness(ALOBKey);