Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6584 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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 ?

Posted

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

  • 2 weeks later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.