I need to send an alert window to a user if the data they are writing to a datapage has a duplicate entry on two fields. (Field1 AND Field2) The fields can't be unique because they need to be able to accept the duplicate fields.
I need a comparison of two concatenated entered values to a database lookup of the same concatenation. I have a working strategy of creating another field in the table that is the concatenated values, concatenating the entered values and doing a table lookup based on the entered values.
I can do the concatenation, but I'm having trouble with the table lookup.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
rreynolds
I need to send an alert window to a user if the data they are writing to a datapage has a duplicate entry on two fields. (Field1 AND Field2) The fields can't be unique because they need to be able to accept the duplicate fields.
I need a comparison of two concatenated entered values to a database lookup of the same concatenation. I have a working strategy of creating another field in the table that is the concatenated values, concatenating the entered values and doing a table lookup based on the entered values.
I can do the concatenation, but I'm having trouble with the table lookup.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.