210
How can i apply a validation on an input field in page level such that all other fields must be filled before allowing this field to get an input value.This field is my primary key.Can a table in bussiness central have no primary key ?I don not have any other unique value fields in this table and if I do not enter a value in this field page shows error
See I understand your requirement you don't want to insert a record until and unless the other fields are filled right? to achieve this you can create a buffer page with variables only fill out the variables and check if all the variables have the values then only the record insert in your table, and to have a unique key you can do the code for auto-incremented unique no as an entry no in the primary key.
i hope it helps you please verify the answer.
Hi Pragya752,
No, you cannot enter all fields before inserting the primary key, and it is not possible for any table to not have the primary key, note that the record is inserted as soon as you enter the primary key in business central, keeping that in mind you can add a procedure to insert all fields from somewhere else after inserting the primary key... so basically you are inserting all the other fields with primary key not before inserting the primary key..
Here's the example where I'm inserting all the other fields from somewhere else as soon as the primary key is inserted..
Hope it helps
Regards
for data filled in fields you can code on the table like
TableRelation = TableName.primarykey;
trigger OnValidate()
var
var: Record TargetTableName;
begin
var.Reset();
var.SetRange(primarykey, Rec."primarykey");
if var.FindFirst() then begin
fieldname := var.ieldname;
.
.
.
end;
end;
but you must specifiy the primary key in table and then you can access the data
and it will fills the fields without editing or entering data.
Hope this helps
thank you
No. A table must have a primary key and if you are doing the input in a page the primary key needs to be filled in first.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (