insert/duplicate update procedure for clients