September 18, 200223 yr Hi I am using Windows 2000 FMP 5.5 Let's say I have three text field name called A, B, and C. The business rule is that I can have one, two, or more the combination of B and C as long as the records that contain of A is the same, but I can not duplicated that combination again if the record has diff data of A. For example: Record # contain A contain B contain C 1 01 B1 C1 2 01 B1 C1 3 01 B1 C1 4 02 B2 C1 5 02 B1 C4 As you see I can have duplicated of B and C of record #1, #2, and #3 because contain of A of record #1, #2, and #3 is the same. But I cannot duplicated for record #4, #5 because contain of A of record #4, and #5 is NOT equal to 01 (in this case) I use SELF counting, but it seems not work properly. Please help Thank you in advance
September 19, 200223 yr Author Hi, Please disregard this topic, I found the solution. Basically I am using SELF Relation to count on number of records. Thank you
Create an account or sign in to comment