Matching entry

[Himitsu]

this maybe a simple question but I am very bad at scripting. I leave out "," and other things that are important. So, I come to the best place for help (even better than FM support).

When I enter in payments for a student, I have two fields (well more than that) the hold the month paid for and year paid for. What I was wondering if someone could help me put the coding together for it to bring up a dialog if the two fields match with a previous record. I want to try and limit double entrys. There are a lot of students so I know my code has to incorporate the relationship of itself to determine if a student has two entries.

Any help would be great. thanks

[Eliz309]

This is just an idea and I am by no means a pro, but you could create a field that combines the information from the other 3 fields(Month, Year, StudentID) then go into the field options and make it unique. This way when you create a duplicate record you will get an error message that the information in that file is not unique.

HTH

[Himitsu]

that sounds like a good idea... I will try that. Sometimes however, the student does have to pay two times in a month. But I am sure that is overideable. thanks.