Field Status history

[jimpres]

I have a field that I would like to save the status on as the information changes. i.e. its a Trouble Report Status field, and has 'open', 'closed', 'work ing progress', 'ECP' etc. at the status pulldowns. What I want to do is keep track to a particular TR as it goes from open to closed and be able to display the info in a global.

I can check the status of the field change but need to know how to store the change with a data associated with the change. I have the global up and working.

thanks,

[LiveOak]

Your description is probably perfectly clear to you as you work on the problem, but it's a little vague to me. It sounds like you wish to comprehensively track data changes at each stage of your trouble report. This will take a little work. I would create a duplicate entry screen with a global field for each corresponding real field. When the user wishes to make a change, a script copies all real fields to the corresponding global fields, the user make edits and clicks "submit", another script compares the original field values to the modified field values and makes entries into a related "Change Log" file indicating what changes were made. Finally, the globals are copied back to the real fields.

-bd

[Anatoli]

That will be the easiest and most reliable way of doing log.

There is also possibility of using automatic check of changes, but it is difficult and I guess slightly less (99%) reliable.

[jimpres]

I appoligize for being vague.

I have a field called status, its a value list with 9 values.

When a Trouble Report (TR) is created it get an "open" status.

Then the status can move through all nine values or just go to "closed".

I have a global repeating field set up to store nine values.

Currently, the status values for any one TR have been imported from Fox Pro and I display them in global repeating field with nine values.

The challange now is to modify that global repeating field with the status changes.

It looks like when the status changes I need to find an empty slot in the repetating field and store the new value. If the repeating field is full then I need to dump the oldest status and fill with the new value. All the time checking to see is the same staus has not already been stored and therefore only change the date.

Hope the mud is a little clearer.