I am having an issue that I can’t seem to figure out.
I have a form for orders and a subform for the lines in the order. The subform is a query so that I can bring in data from another table product when viewed in the form so it is more easily human readable. If the query is not a subform I can insert and update records without issue. If the query is set to a subform Libre Base will crash when ever I try to make a change to the query table.
The strangest part is after I restore the file and open the database again the data is in the table. Is there anything I can do to make it work?
I have attached a copy of the database if anyone wants to take a look.
The form in question is Customer Order
Main form CustOrder table