Hi, I have three dropdown listboxes and a multi select list box. When user selects values in all the DDLB and MSLB, the values are inserted into repeating table. I want to validate for duplicate entries in the repeating table.
Here's how my repeating table looks like:
Row 1 -- > Cluster1 | Pathway1 | Program1 | Course1, Course2,Course3
Row 2 --> Cluster1 | Pathway2 | Program2 | Course2, Course4
Row 3 --> Cluster1 | Pathway1 | Program1 | Course2
I am able to validate for duplicate values as a full string using concat function and preceding:sibling function. But I want to able to validate for every course selected with combination of cluster,pathway,program. In this case, Row1 has Course2 with cluster1,pathway1,program1 and it should validate when Row 3 is entered with same Course2 with cluster1,pathway1 and program1.
Please can anyone help me with this issue!!!