Thanks again tom,

the code in staff is pretty good to check the duplication. It works!


While for the other question,

I have a field that I want it showing as NON EDITABLE in search detail page, I tried to put {rlog} but every time it is saved, the field turns blank.

I tried all combination, didn't find out the right one..
Can you advise me?

Let's suppose you want to make first_name non-editable. Then,

(1) change (fd) to (my-new-key) in XA_LIST of first_name

(2) Open web/staff/app/cls_ps_(your-table-name).inc.php and insert $ls[] = "(my-new-key)"; after $ls[] = "(rlog)" like

$ls[] = "(rlog)";
$ls[] = "(my-new-key)";

There should be two places. One is in the case 'edit_init': block and the other is in the case 'edit_inp': block.