January 1, 200718 yr I have an application where there are two fields on the current layout that are keys to create records in another table. ; style & color. There are quantity fields that are also part of the relationship. My problem is that a user can input the style, color and quantities, then change either the style or the color, and build a whole new relationship, leaving the first set of records intact. So if someone creates a record, inputs the values, an then changes their mind, I will be left with line items that should not exist. Is there a way to prevent modification of a field after it conatians a value ? I have messed around with scripted validations and FM8.5 field validations, and have not hit on a good solution. Am I missing something ?
January 2, 200718 yr You could approach this several ways... 1. Permissions calculation (see security concepts ... that really will stop them) 2. Layout navigation ... one editable one view only ... kind of cosmetic approach
January 15, 200718 yr Author Thanks Stuart. Sorry I was so long in answering, been away for awhile. Skip
Create an account or sign in to comment