Hi Derek,
I've been studying this project night and day for 3 days, I've completely lost my mind, I've even managed to create a button that opens the same form.
Obviously, as you always guessed the purpose, he had to open the form 'frmNuovoProdotto' and not himself and you got it right: I would like to insert more products in the invoice.
To make this project I first studied the example project "Invoice" which is downloaded from the site of which I tried to follow in its footsteps.
As you suggested, I moved the relation field from the 'Fatture' table to 'Prodotti', which was also the system used in the example I followed. I had tried to do a little by myself without just copying.
In the example, Dimitri has put the "Date" field in the Customers table, so I did too even if it seems a little logical to me since this field relates to the invoice. But if it has to be done this way to work well, then it's done this way.
So I went a little further: I set up a calculated field (Totale) in the 'Ricevuta' table to do the calculation of the item for the quantity. And here I would say that it works: he inserts the item in the invoice and makes the correct calculations.
Now the problem that arises is in saving the invoice (frmRicevuta) and more precisely in the save button 'bSalva', I get an error.
I support your idea of making things as easy as possible, so if you have any other suggestions to improve this project, please let me know.
Thanks for everything derek
Post's attachments Ricevuta.zip 1.06 mb, 70 downloads since 2023-06-26