Gwen Posted January 21, 2005 Share Posted January 21, 2005 Hello. I have a table with 56 fields and 8 records (with data entered for some, but not all, fields for each record). I would like to constrain some of the fields to always include a fixed value. I tried using "auto enter data" and specifying a value (say '100'), both with and without "global storage" on. Why don't my existing records automatically update to show this value in the appropriate field for every record? I tried asking for validation (always) and specifying validation by calculation (e.g., [field] = 100. But my records still don't update to show this value. When I add a new record, it does automatically show the specified values in the appropriate fields. Sometimes it also updates the existing records -- but not always (only when global storage is on). I am having a similiar problem when I try to update some existing data fields by asking for a look-up. The fields do not automatically update, although there are appropriate links between two Tables, and the data exist in the look-up table. Help! This seems like something that should be very easy. Thanks, Link to comment Share on other sites More sharing options...
This topic is 6633 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
Already have an account? Sign in here.Sign In Now