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 ?

(0) Share

Report

Posted on by Pragya752

234

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

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Suggested answer

IB-29041624-0 1,177 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Shrey Chauhan 286 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Govinda Kumar 2,304 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Tech-Lucky 1,286 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No