Finance | Project Operations, Human Resources, ...

how to limit the record insertion in a table

(0) Share

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.

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

nmaenpaa 101,166 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
vikash_ 210 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,166 Moderator on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No