Hi,
I am using Libreoffice 6.4.7.2 (x64) with HSQLDB SPlit database in Windows 10 and I am wondering if the following is possible in any way or form.
If I have an item and this item has a price value. If I call the item into a form and will change that Price value within the form, is there a way to keep the original price value unchanged in the table where that item is?
Hello,
This needs a bit more explanation. There should be no method where a table value when displayed in a form is changed unless there are possible other factors involved which you have not revealed. One possible situation may be a field linked to another table using a list box and thus picking up a current price vs the price when originally entered.
It would be best if you could present more information and even post a sample DB where this is happening. You can zip a split folder - rename extension to .odb and note that when posting to change t back to .zip
@Ratslinger ! thank you very much for your answer and really hope that you are doing well wherever you are. It basically is an invoice form where I had created items, each item has an Msrp and a net price before VAT. So on occasions I will need to adjust this net price for some reason but I would like to avoid to thus modifiy the official net price in my items table as this could lead to mistakes. A light has gone up when you mentionned the field linked to another table but I am not 100% sure that I understand. Thanks for sharing your knowledge and please let me know in case I am not being clear enough.
All is well here and best to you also.
Unfortunately, at this point don’t know how to help further without a sample to see exactly what you are dealing with. Will think more on this and hopefully you can provide some type of sample showing the problem.