Button to save records with strange behavior (Page 1 of 2)

Ciao Fabio purtroppo non puoi salvare dallo stesso form su un solo database, salverà sia azienda sia cliente che prodotto.
Avendo come campo obbligatorio il cliente se non inserisci prima il cliente non ti farà inserire il prodotto

Ciao Domenico, grazie per la risposta. Questa cosa di più pulsanti di salvataggio nello stgesso form non l'avevo proprio immaginata. Cercavo di farlo più minimale possibile ma dovrò per forza aggiungere qualche form. Mi sembrava una buona idea quella di avere tutti gli inserimenti in una sola finestra ma dovrò adattarmi.
Già che ci sono vorrei chiedere un'altra cosa: siccome nella tabella 'Azienda' ci andrà solo un unico record sono i dati relativi alla propria azienda, quale potrebbe essere il miglior modo per, diciamo, "bloccare" la tabella ad un unico record? Cioè una volta inseriti i dati dell'azienda si possa solo modificare i dati e non che venga creato un altro record.
----------------------------------------------------------------------------------------------------------------
Hi Derek,
I hadn't thought that even though I put a TableSheet things are not divided but the form remains the same. It seemed like a good idea to have all entries in one window but I'll have to adapt. Thanks for the explanations and the possible alternative.
While I'm at it, I'd like to ask something else: since only a single record will go in the 'Company' table, it's the data relating to your company, what could be the best way to, let's say, "lock" the table to a single record ? That is, once the company data has been entered, it is only possible to modify the data and not create another record.

Hi Derek, Fabio

Unexpected, but it seems to work. At least for a new record.

Now if you also tell me how to save the 0s in front of a number in an integer (I tried real too) field because I tried everything but I couldn't. If I write 00123 he saves 123.
I am very grateful to you.

Sorry sparrow, i didn't understand.

Hello all, thanks derek for the clarifications, I understood very well the question of the type of field and when to use them and I changed the text as you suggested.
In the meantime, I went a little further in the structure of the program that I am attaching.
As you can see, I added a 'frmRicevuta' form in which I put the 'bNuovo' button with "New Record" action but the button doesn't open the 'frmProdotti' form as it should.
Maybe for the same opening speech that you can't put two "Save" controls on the same form?
In this case I set the "NewRecord" property to the 'lbCliente' Label via script when it is clicked.

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

Ciao Domenico,
ho visto le correzioni e più o meno ho capito. Quello che però non mi spiego è perchè non funziona come l'ho impostato io che l'ho fatto sulla falsa riga dell'esempio scaricabile dal sito.
Hai cliccato sul tasto OK all'avvio del programma?

Eppure è quasi uguale, almeno in struttura, all'esempio "Invoice" e che funziona. Ero curioso di capire perchè non funzioni.

Привет Derek
Подскажи пожалуйста, как сделать сохранение тестовых полей (переменных) в отдельный файл, а при загрузке что бы они уже были введены в свои поля, минуя таблицу баз данных.
Заранее благодарю за ответ

Hi Derek, hi everyone,
thanks for the suggestions always welcome. Your project is very nice and corresponds to what I wanted.
The thing is, when I don't understand something, I stubbornly stick with it until I understand it.
Sometimes, then, it seems to me that in some projects something doesn't work for me that worked for me in others and then I get stubborn even more. Certainly it is a feeling, if they are the same they must both work.
For example in this case I tried to make the project along the lines of the "Invoice" example downloadable from the site. That works, mine has this problem. The only difference is that in the example there are two textboxes for the customer's name and surname, while I had placed a combobox.

Hi Derek,
when using the program, when you click either on the "Salva" button (frmRicevuta.bSalva) or on the "Aggiungi prodotto" button (frmRicevuta.bNuovo) it gives me the error of the screen shot that I insert in the attachment).If at the "Salva" (frmReceipt.bSalva) I remove the property to save the record then the "Aggiungi prodotto" button (frmReceipt.bNew) works.