News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... how to limit the recor...

Finance | Project Operations, Human Resources, ...

Suggested answer

how to limit the record insertion in a table

(0) Share

Report

Report

Posted on by vikash_

210

I have three forms Book Trans, BookTable and student table. I want to insert five transactions in the BookTransaction form with the same student id(field in student table) and stop when it triggers the sixth time.

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

nmaenpaa 101,156 on at

Like (0)

Report

RE: how to limit the record insertion in a table

Do you still have some open question?

You wrote "I have three forms Book Trans, BookTable and student table. I want to insert five transactions in the BookTransaction form with the same student id(field in student table) and stop when it triggers the sixth time."

and

"I want to insert 5 record with one Studentid,more than that it should throw error.

And there are 4 student id"

It doesn't seem consistent.

If you have some question, please explain the process and expected outcome. Thanks!
vikash_ 210 on at

Like (0)

Report

RE: how to limit the record insertion in a table

Thank you for reverting back,

I want to insert 5 record with one Studentid,more than that it should throw error.
And there are 4 student id
Suggested answer

nmaenpaa 101,156 on at

Like (1)

Report

RE: how to limit the record insertion in a table

Add check in validateWrite method, calculate existing records and return false if there are already five records.

Helpful resources

Quick Links

Leaderboard

#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

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans