Duplication

[LuckyMe]

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

[LuckyMe]

Hi,

Please disregard this topic, I found the solution. Basically I am using SELF Relation to count on number of records.

Thank you