Prevent related table field from being entered more than once
I have a problem which would seem as if it's painfully obvious to solve ... but I can't find the solution at all.
I have a layout that includes a couple of fields from a related table. Every time data is entered into one of the fields it creates a new record in the related table. The problem is that if the user adds data to the field, commits it and then decides that they want to go back and change it, both sets of data will be added to the related table in the form of two separate records.
I've fiddled around with scripts to lock the field once it's been entered, but it doesn't work so well. There's gotta be a more elegant solution to this...
Thanks in advance