automated field

[stanley]

I'm working on a manufacturing database. I've got a "Job Status" field which tells where the job is in the workflow (Received, Underway, Shipped, etc.) and I want the field to automatically change when another field (the Date Scheduled field) is changed. In other words, when a manager schedules a job, I want the field to automatically reflect this by changing from Received to Scheduled.

To be simpler:

How do I make it so that any entry into one field causes another field to have certain data pasted into it?

thanks,

Stanley

[Steven H. Blackwell]

Make Job Status a calculated result dependent on the otehr field.

Old Advance Man