Jason,
Thanks. That worked great.
Now the more complex part - how can I insert a "-1" at the end if there is already an entry for "Senior Sales Associate", or insert a "-2" if there are already 2 entries for "Senior Sales Associate", and so on?
Upon insert, I would need to check the database for matching entries in the careerTitle database field, count them and add increment if needed in the compiled careerPermalink database field.
Or maybe i just need to make sure the "careerPermalink" field is unique and increment it if needed? No sure how to do this.
Appreciate any further help.
Daniel