making formatted id as the primary key of my table and

go

raiserror('creating Personal table....',0,1)
CREATE TABLE tblPersonal
(Membershipid int IDENTITY(1,1) ,
FormattedMembershipid AS ('COP/PIWC/ATOM/' + RIGHT ('000000' + CAST(Membershipid AS VARCHAR(6)),6)),
Regdate datetime,
Assemblys varchar(30)not null,
Surname varchar(100)not null,
Othername varchar(100)not null,
Gender varchar(10),
Nationality varchar(200))

go

raiserror('creating Transaction table....',0,1)
CREATE TABLE tblTransactions
(Transactionid int IDENTITY constraint pkTransid primary key clustered,
FormattedMembershipid varchar(300)foreign key (FormattedMembershipid) references tblPersonal (FormattedMembershipid), 
Datepaid datetime,
Surname varchar(100)not null,
Othername varchar(100)not null,
Assemblys varchar(30)not null)