I am looking for the best option to handle the following scenario:
1. I have a Orders table loaded from QVD
2. Client can select a record from this table and make someindividual items' changes in this record.
3. Client can make a new Order
4. So I would need to update the original Orders table with modified (#2) and new (#3) records.
I've used an Export Action, but it has several limitations I would like to avoid (exporting to QVO or TXT file only, requires partial reload, no direct access to the table, unability to add Autonumbered Record ID, date and time, etc).
I would appreciate any suggestions how to handle this case.