I have 10 text items in a block. User enters a document no. viz from 1-24 (any 10 at a time or even less that 10, but atleast one doc.no.). The problem is, if the user enters 1 or 2 or 3, etc, he should not enter the same no. in other 9 text items. That is the primary key is both the emp_no and the doc.no.
I can do this using IF condition, but for the 10th text_item, I should use the IF conditions more thn 8 times. So is there any other method to achive this. If the text_item are more than 50 , I can keep checking using IF condition. How to do this.
Create a hidden list item, whenever user enters a doc no, insert that value into that list item. U can set the list item to reject duplicates. So if the duplicates are ever entered, an error will be generated and u can trap that to display it to the user.
Make sure to clear the list item after the record is inserted into the database.