Small and medium business | Business Central, N...

Unique record in table

(0) Share

Report

Posted on by khudeja

305

I want to insert a record simultaneously in two tables by entering the data in one card page. I wrote the code for inserting into another table inside the OnClosePage trigger of the card. It saves a new record fine but gives an error on reopening and then closing the page for the same record(the record with the same primary key already exist). How do I fix it? Am I using the wrong trigger or is there any validation statement that I need to put to check whether the record already exist?

Thanks

Khudeja

All responses (2)

Answers (0)

Sort by

Hannes Holst 5,767 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You could add something like this

If not YourTable.Get(YourPrimaryKey) then
CreateNewRecord();
Suggested answer

Avinash B 1,455 on at

Like (0)

Report
Copy link

Link copied!

Hi

You can also make use of the SetRecFilter.

RecVariable.Init();

.

.

.// Assign the values to the RecVariable

.

RecVariable.SetRecFilter();

If RecVariable.IsEmpty() then

RecVariable.Insert() // Insert the record if hasn't found

Else

RecVariable.Modify(); // Modifies the existing record (if any changes).

Regards

Avinash B

Join the conversation

Community site session details

Unique record in table

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Unique record in table

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates