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)

Verified answer

Tech-Lucky 1,255 Super User 2025 Season 2 on at

Like (0)

Report

RE: 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 ?

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
Verified answer

Govinda Kumar 2,211 Moderator on at

Like (1)

Report

RE: 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 ?

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
Suggested answer

Shrey Chauhan 276 on at

Like (1)

Report

RE: 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 ?

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
Suggested answer

Inge M. Bruvik 1,035 Moderator on at

Like (0)

Report

RE: 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 ?

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