Flappy Posted January 1, 2007 Posted January 1, 2007 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 ?
Stuart Taylor Posted January 2, 2007 Posted January 2, 2007 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
Flappy Posted January 15, 2007 Author Posted January 15, 2007 Thanks Stuart. Sorry I was so long in answering, been away for awhile. Skip
Recommended Posts
This topic is 6584 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now