Solved: Prevent duplicate in details tables (with "part of... - Page 2

pmhungdao · 11-22-2021 03:45 AM

Hello,
I have “Order” and “OrderDetails” tables, link with OrderID fields, and option “Is a part of” selected. “OrderDetails” has a field “Serial”, which should not be duplicated. However, I found out that because of the “Part Of” option, when creating new records for “OrderDetails”, it will not be saved until the “Order” table is saved, and I don’t know how to prevent the duplication in this situation.
Can anybody help showing me what to do to achieve this?
Thanks.
Anh Han

Suvrutt_Gurjar

Have your tried an expression something like below in the Vlaid_if of the [Product Serial Number] column in the Order Details table?

I tried it in the sample app with “Is Part of Setting” between Orders and Order details and duplicates are prevented with the suggested expression.

Please refer the last section of the article below.

View solution in original post

Prevent duplicate in details tables (with "part of" option)