AnsweredAssumed Answered

Check duplicate value of a portal

Question asked by sam0723 on Jan 26, 2018
Latest reply on Jan 31, 2018 by sam0723

hi, i am new to filemaker. i would like to check if there is any duplicate value entered by the user. Currently, i am using script trigger to check each portal line record of specific parent record(using find records in line items table). But some user reflects that it is annoying after data entry.


Is there other methods to check or prevent the duplicate of the line items? is Relationship a possible solution?


Currently, the structure of the database is


People --> Orders --> Orders line item

The current layout is Orders table, the portal is line items.


i am using filemaker 15.


If my description is not clear, please let me know. Thank you.