Search options (Page 13 of 14)

Portrait, in the real project the problem also occurs with version 5.2
Look, the combobox is in the 'frmInserimentopc' form.
You can get there from the "Computer" tab by clicking on "Insert" in the attached project.

Hi Derek,
reviewing your changes in my project I discovered another big problem: the dates of 'arrivomerce' and 'Scadenza' can not go to 'frmFornitore' because it would put me the date when the customer is created and not when the goods entered that among other things, it can enter several times and therefore with different dates.
So, following the study of your changes, I moved the date fields in the 'Arrivo'Merce' table instead of in 'Anagrafica' and entered the controls in the 'frmArrivomerce' form.
Then I made the appropriate changes to the properties of the various TableGrid and buttons.
I seem to have done everything correctly and that it works well.
Too bad I can not enter the checks for dates in the search form, but it's not a problem.
I enclose the project with the changes indicated.

I don't know how to thank you Derek! There would be this little problem: in the report I reverse the Counter field with the contract number, in the upper right corner, with the customer code though it would seem that the two counters are placed in the right place (record_count_1 of the table ' ArrivoMerce' at the top Right and record_count of the table ' Anagrafica ' first field in the report, under the heading "Codice Cliente").
I could just reverse the two fields in the report but I'd like to understand why it does.
I've done some testing in your project, but I can't figure it out.

Hi Derek,
' NumeroDocumento ' of the table ' Anagrafica ' is relative to the ID of the document (identity card, driver's license, passport, etc.) so it's okay that there is only one.
The database is for a second hand market, whenever a customer brings something to sell you have to generate a contract, in the field ' Arrivomerce ' There goes the number of a document with the list of items that sells generated by a management program. The Tablegrid in 'frmFornitore' is used to be able to add a number of ' arrivomerce ' each time different, because the same customer can bring things to sell several times and each time a new contract must be made.
Isn't there a way to take the data from the Tablegrid in the first form simply by selecting the line?
Your solution works but it is a bit particular how to get to print, especially for those who are not very practical computer. If I had to use it I wouldn't have been problems.

Yes it works, that's just what I wanted, select a record from the Tablegrid and print the data of the selected record. I just didn't understand what you changed to make it work.
Thanks always so much

This I think you have solved it: I set as "components involved in the search" only the Tablegrid, seems to work, I hope I did it in the correct way.

Thanks Derek you are very kind. So is the only solution to put every field in one table?

Hello, thanks for the reply. In fact, I deleted the counter field before sending the project. However I understood that I did not understand, the project in general has many gaps. I'm covering a bit 'all the project, then once set well, I'll come back to ask for this information if I have not understood it alone. Thanks again

Well, thank you very much, that was the passage I missed, thanks to Derek for the script and all those who responded. Now it works well.