HI,

I am running FMP 7 Dev Windows XP.

I posted this question before under subject: "Show Message", but I don't think I made myself clear, so here I am again. Sorry

I am trying to build a simple Tennis Registration DB for a non-profit tennis center here where I live.

I have three files: Student, Class, and Registration.

Student.FP7: for Student information such as: Name, address, etc.

Class.FP7: list all current tennis classes information such as: classID, ClassName, Day, and Time and coachName

Registration.FP7: Serial#, StudentID, StudentName, ClassID, ClassName, etc.

Registration file related to Student by StudentID to get StudentName

Registration file related to Class by ClassID to get ClassName

One of the validations I would like to check is that each record should be uniqued by StudentID and ClassID, otherword there MUST be not a duplicated record by StudentID and ClassID

Here is how I did to check if there is a duplicated record by StudentID and ClassID:

1. Make a SELF relationships from Registration file by StudentID to StudentID and ClassID to ClassID.

2. In validation tab: I checked checkbox

Search the TechInfo database on the FMP web site for info on validating a calculation field.

Hi Vaughan,

I found the article on FMP website called: "New Validation Features And Behavior". I read it carefully and understand it very clear (I think).

However it still show me two messages. I ran some testing and it seems work fine (ONE message) if I don't have my own calculated Validation, otherword if I use simple FMP validation such as "not empty, Unique value, etc.", then it works fine, and show only one message.

I am sure I am missing piece here, but could not figure out what it it.

ANy idea please?

The attached file is a very simple FP7 file for testing this issue.

Thanks

Here is the testing file. I think I forgot to attach from previous reply.

Sorry

Validation.zip

That's a good article, but not the one I was refering to.

http://www.filemaker.com/ti/104191.html

Hi,

I read the article, and I have been using SELF Join to check the duplication. It works find with ealier versions until I upgrade to FMP version 7.

What do you think?

Thank you for your time?

HI,

I just create a new file version 6 by using the exact idea from the article to chekc duplicate record, it works fine: just ask me one error message (my custom message) when a duplicated record occured. I do the same thing in version 7, it show me two validation messages?: The attachment is my another testing file verison 6

Any advise Please?

Thanks

Sorry I missed to attach the file again

TestDup.zip

Hi,

This is another attachment, it is the same file but it IS version 7 that converted from version 6

Thanks

TestDupver7.zip