gaby78 Posted May 24, 2006 Share Posted May 24, 2006 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 Link to comment Share on other sites More sharing options...
Søren Dyhr Posted May 24, 2006 Share Posted May 24, 2006 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6540 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now