hi
Please refer this code.
********** Table for the setup **************
table 50102 "Entitlement Setup"
{
DataClassification = ToBeClassified;
fields
{
field(1; "Primary Key"; Code[20])
{
DataClassification = ToBeClassified;
}
field(2; "Entitlement Nos."; Code[20])
{
DataClassification = CustomerContent;
TableRelation = "No. Series";
}
}
keys
{
key(PK; "Primary Key")
{
Clustered = true;
}
}
var
myInt: Integer;
trigger OnInsert()
begin
end;
trigger OnModify()
begin
end;
trigger OnDelete()
begin
end;
trigger OnRename()
begin
end;
}
*********** Table for creating the records *************
table 50103 Entitlements
{
DataClassification = ToBeClassified;
fields
{
field(1; Code; Code[20])
{
DataClassification = CustomerContent;
trigger OnValidate()
begin
IF Code <> xRec.Code THEN BEGIN
EntitlementSetup.Get();
NoSeriesMgt.TestManual(EntitlementSetup."Entitlement Nos.");
END;
end;
}
field(2; Description; Text[100])
{
DataClassification = CustomerContent;
}
}
keys
{
key(PK; Code)
{
Clustered = true;
}
}
var
EntitlementSetup: Record "Entitlement Setup";
NoSeriesMgt: Codeunit NoSeriesManagement;
NoSeriesG: Code[20];
trigger OnInsert()
begin
// Value will be filled automatically on insert by getting the next number from the series
IF Code = '' THEN BEGIN
EntitlementSetup.GET;
EntitlementSetup.TESTFIELD("Entitlement Nos.");
NoSeriesMgt.InitSeries(EntitlementSetup."Entitlement Nos.", '', 0D, Code, NoSeriesG);
END;
end;
trigger OnModify()
begin
end;
trigger OnDelete()
begin
end;
trigger OnRename()
begin
end;
}
Regards
Avinash B