In a simple Invoice table/LineItems table scenario I want to prevent the entry of duplicate product IDs in a portal based on LineItems table. This is to keep the user from choosing twice the same product code on the same invoice.

Ideally it would go like this: If product P313 has been entered twice in same portal, show message "You entered a product twice"

I tried a few things but no luck so far.

Thanks for any suggestions

If you first build a found set, can it when it's finished be imported into the lineitems table, this can be accomplished with a few hacks in this template, where everything then goes on in the items table:

http://www.fmforums.com/forum/attachment.php?attid/7439/

--sd