I'm not sure if I need a calc. or a script for this. I have three fields from the same table on a layout. The first field is called "target date". The second field called "schedule" has radio button options 0, 30, and 60. The third field is called "completion date". I want to make sure that "schedule" has a value selected in it before someone enters data into "completion date". If there is no value, they need to be alerted by text.

The reason I'm doing this is because I'm going to try and create a script to automatically create a new record that has a target date of x number of days from the previous completion date.

Greg

Layout Mode | Field | Options | Validation | Not empty | Display custom message if validation fails

Hi transpower,

I don't necessarily want to HAVE to enter data into "schedule" right away. I would prefer if a person could:

1. Enter a "target date" for this work to be done... then,

2. Come back another time and tell the database "how many days" until the next scheduled work project should be targeted... then,

3. Come back another time and tell the database when this project was completed.

4. When that time is entered the database creates a new record with a target date x number of days after this one's completion date.

I kind of hate to have them hit a button to schedule the next maintenance date. Of course, I think the way I'm trying to figure out would be bad if someone decided to change the completion date (since they might have typed it wrong the first time) and it would create a second copy that is slightly different.

Is this possible?

Greg