if (StructKeyExists(URL,"newRefFk")) session.RefFk = URL.newRefFk; jsOnLoad = "initrefs();"; session.RefFk = form.RefId; session.ReferenceDetail = form.ReferenceDetail; SELECT dbo.f_web_NextFreeRefDetailId(7000000) AS Id INSERT INTO RefDetail (RefDetailId, RefFk, Details, PreliminaryFlag, Created_When, Created_Who) VALUES (#session.RefDetailFk#, #session.RefFk#, '#session.ReferenceDetail#', 0, GetDate(), '#session.username#') UPDATE RelName SET RefFk = NULL, RefDetailFk = NULL WHERE RelNameId = #url.RelNameId# UPDATE RefDetail SET RefFk = #session.RefFk# WHERE RefDetailId = #session.RefDetailFk# if (session.RefFk eq "") session.RefFk = "NULL"; if (session.ReferenceDetail eq "") RefDetailFkTemp = "NULL"; else RefDetailFkTemp = session.RefDetailFk; UPDATE RelName SET RefFk = #session.RefFk#, RefDetailFk = #RefDetailFkTemp# WHERE RelNameId = #url.RelNameId# UPDATE RefDetail SET Details = '#session.ReferenceDetail#' WHERE RefDetailId = #session.RefDetailFk# DELETE FROM RefDetail WHERE RefDetailId = #session.RefDetailFk# SELECT Reference.RefId, RefDetail.RefDetailId, Name_1.FullNameCache AS Name1, Name_2.FullNameCache AS Name2, Reference.RefId, RelNameQualifier.RelNameQualifier, RefDetail.Details FROM RelName INNER JOIN Name Name_2 ON RelName.NameFk2 = Name_2.NameId INNER JOIN Name Name_1 ON RelName.NameFk1 = Name_1.NameId INNER JOIN RelNameQualifier ON RelName.RelNameQualifierFk = RelNameQualifier.RelNameQualifierId LEFT OUTER JOIN RefDetail ON RelName.RefDetailFk = RefDetail.RefDetailId LEFT OUTER JOIN Reference ON RelName.RefFk = Reference.RefId WHERE RelName.RelNameId = #URL.RelNameId# session.BackFromEditTypeReference = cgi.http_referer; session.Name1 = TypeReference.Name1; session.Name2 = TypeReference.Name2; session.RelNameQualifier = TypeReference.RelNameQualifier; session.RefDetailFk = TypeReference.RefDetailId; session.ReferenceDetail = TypeReference.Details; session.RefFk = TypeReference.RefId;

Edit reference for "#session.Name1# #session.RelNameQualifier# #session.Name2#"
Reference	Select new reference
	Remove
Reference Detail

Edit reference for "#session.Name1# #session.RelNameQualifier# #session.Name2#"