[FAQ000008]When creating a screen for master registration, how can I check for duplicates?

Q

When creating a screen for master registration, I would like to make duplicate errors for items that have already been registered in the table when registering them on

the new registration screen, how can I check for duplicates?

A

You can use the action list attached to the registration button on the registration screen to perform the check.

In the "Data manipulation" category, there is a block called "Retrieve one item from table". Here, you can specify

whether or not the column you want to check for duplicates matches the input value cell as the search condition, set the search result to any cell set as a hidden row,

and check for duplicates based on the presence or absence of the search result.