

In your spreadsheet file, rename the column headings so. So how do I go about this? Mainly what I can’t seem to find how to do is populate a field with something and save it as something else. xls files can also be opened and edited by the Microsoft Excel Viewer, and OpenOffice. Lastly I want the InvoiceLine Total to equal Product x Quantity and Invoice Total field to automatically add all the InvoiceLine Total fields. Similarly in the main form I want to be able to type a customer code into the customer code field, and Auto-populate a few other boxes with the customer info, but this will not be saved into the invoice table. But when I type an item code in the Code section of the InvoiceLine field I want it to Auto-populate the price and info fields in the InvoiceLine subform So I want an Invoice form and InvoiceLine sub-form.

But I do want customer info to change when I change that. Hey! so I am writing an Invoice form but I need one thing different from normal: I don’t want past invoices to change when I change item prices. Simple Invoice Template for LibreOffice No surprises is a good rule for client relationships.
