Validation from Pending approval table failed

Summary:

Unable to validate based on Approval TAble.

Content (required):

Dear Abhishek,

We have an element Child Allowance with multiple entries. However, we define input values as child name. Our requirement is to validate if employee submit transaction if same transaction exist in either "Element entry" table or " Approval" Table.

Now we have successfully created two values set and each one have different error message in order to inform employee as Pop-up Message.

Now problem is when i submit first time transaction then system allow. However, before approval if i again submit the transaction then system raise an error that " you can not submit because same transaction is exist in approval".