Compare Results of Records with Duplicate ID Fields
I'm new to Filemaker Pro and I've run into a problem.
I have a database of pre-test and post-test results, with each record having an ID field. What I would like to do is be able to is compare the results of each specific pre-test result with that of the post-test. Some students only took the pre-test, some only took the post-test, and some took both. Those that took both will appear twice in the database (because of duplicate ID#s). These are the one's I am specifically interested in.
Said in another way:
I want to compare John's pre-test with his post-test. I'd like to be able to do this for all duplicate IDs.
I don't want to compare all pre-tests with all post-tests.
Thanks very much!