Hi,

This has a couple of steps so apologies in advance.

I am rather new to Creator and I am attempting to build an Asset Register.

I am hoping to be able to develop an Asset history based around field updates of a record.

Let's say I have the following fields:

- Manufacturer (asset_man)

- Model (asset_mod)

- Asset Tag (asset_tag) [unique]

- Serial # (asset_ser) [unique]

- Status (asset_sta)

- Location (asset_loc)

- Notes (asset_not)

When someone makes an update to either Status or Location, I would like to keep a rolling history of these events, And potentially trigger a "More Info" pop-up, so that I can ascertain the service and installation history of an Asset since it's creation.

As an example, if Asset-001 changed status from DEPLOYED to OUT FOR SERVICE it would be great if on making that change the user is prompted to provide more detail for the cause of change eg. "3000 hour service required". This INFO, along with UPDATED FIELD, NEW VALUE, OLD VALUE, TIMESTAMP, and ASSET TAG would then be recorded elsewhere. (I am assuming I will need to gather this info to a separate form/table which I can then filter by Asset Tag).

This leads me to the second part, if I am able to generate this information, it would be ideal if it could be displayed on the DETAIL view of a report. eg. Clicking on a record in a table view of all Assets would bring up the original fields (manufacturer, model, asset tag etc.) and also provide a view of the asset's change history...

Any thoughts or suggestions?

Thanks for any help. I've managed to get everything else working but this is the missing step I need to rectify before making the register liver for use.

TiG