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.