Jump to content

Duplicate child records in Portal


gaby78
 Share

This topic is 5673 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

This topic is 5673 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.