Allow new table define via Application Designer to have user defined unique key
Please allow Application Designer to create new table with a user defined unique key, made up of one to many fields, instead of the system generated unique key. This will allow us to create, in my case, a Transaction table that we can open up to other systems.
We were going to use the amInputEvent table as a transaction table with 1 new field added. Internally it works great, but we can't get it working with the external system as they cannot generate the lInputEventId.
In our case, we would like to create a table very similar to amInputEvent, but replace the lInputEventId key with one made of Asset Name(Asset), Creation (dtCreated) and Category (Category) or whatever we decide on.
This will allow us to open up the Transaction table to other systems to do simple tranactions with Asset Manager records, like change the status of a server, define/Change a server Point of Contact etc.
See attached for a Example.