Hi,
Trying to make a long story short. I want to build a software that I can use to conduct an audit of different softwares, updating things like, licences, cost, users, departments etc. I may not find all of this info in one go so want to be able to add the info in when needed, i.e. and Edit form.
However, I don't want to overwrite any data, as I will need a historical record. Is there a way I can make it an Edit form unless its not blank but then pull the info from the last entry into the new form submission i.e. if the just the cost changes but I need to keep old and new cost, it pulls everything else across without overwriting the old?