Prevent Duplicate entry in a month

USMAN55

New member
Local time
Today, 14:26
Joined
Jan 21, 2022
Messages
1
Hello

I have a database for pay pensions and i want to prevent duplicate entry in a month of each pension account
I.e i have account number 4124A and i want to create only one entry in a month.

how i create it.?

here is the form view i have use for transaction.
 

Attachments

  • form view.JPG
    form view.JPG
    39.5 KB · Views: 274
You need to add a field to hold yyyy/mm, using a calculated field is best. Then you can make a unique index on Account + the ym field. To create a multi-field unique index, you must use the indexes dialog.
UniqueIDX4.JPG
 
Hi @USMAN55. Welcome to AWF!

You could also try using the BeforeUpdate event of your form to prevent duplicate entries.
 
you can also add a button in your form that will open a Form
with the Last Transaction of the Account owner.
 

Attachments

Users who are viewing this thread

Back
Top Bottom