Match Tablegrid with Combobox

The development environment does not support cross-tabs (what you need, judging by the picture), but you can achieve the desired display using a script. However, its implementation will take time and effort, and performance for 1000 patients will leave much to be desired. For this reason, the master/detail view is used in such cases. But if the waiting time for generating such a report is not critical, then you can try to implement it. The plan is this: using the SQLQuery procedure, obtain the initial data set, and then fill the cross-table row by row in a loop; first, using a separate query, you need to get a list of medications and add the corresponding number of columns.

Thank you sparrow and K245
fixing the first columns permanently will also help me.
this project is for a doctoral thesis and it will be effective when comparing a specific antibiotic for some patients ( not all of 1000 instances)  who took that medicine and those who did not take it.
I know it will be difficult to compare as there will be many rows and columns but  it will definitely fit my purpose . besides I have no other choices.
is there any script that match that combobox in Drug Form ( Antibiotic Type ) with a specific column of the tabelgrid in the Search Form?
For example the first line of combobox is shown on the third column of the tablegrid
but still there is another unsolvable obstacle which is the 2 textboxes ( Number and price of antibiotic) that are related to that combobox.
So I guess there is no solution to this approach
thank you guys for trying to help

Something like this
35 antibiotic positions have been added for the test

Just need to be careful.
Due to the simplified patient database, the result will be incorrect if the first and last names of some patients match.

Hi Fabio,

First, let's solve the problem of duplicates. Here's a slightly modified procedure:

group by 1, 2';

Replaced by:

group by id_patient, 1, 2';

The task that the author set for himself and us and the solution to this task is called rotating the table (pivot table). From vertical to horizontal. And this is not a trivial task.   Especially with more than 30 columns. Where can you reach the limit on the number of characters in a request? Although in Excel everything is quite simple.
Now to the issue of editing. Let's say 15 vertical records are moved to 35 horizontal ones in their places. Now which of these client records do you want to edit??? All at once, 1, 11 or 32??? And under what ID? What if the data is also summarized from several lines? 
This table rotation is usually the final report and is not intended for editing. I hope the author understands this too.
Now for editing we need to look for another solution.
And the decision itself is not difficult.

I wouldn't like to think that this is some kind of test bed on patients.   
Maybe I can prescribe you another pill like this? ))))
Most likely this is an analysis of treatments, including costs. Alive but poor or half-dead with some savings)))

It’s better to be on this side of the statistics))).
Good health to everyone.

Fabio
attenzione ai software per ospedali in Italia le norme sono molto severe!
un abbraccio!

Now that's the script I have been looking forward to.
thank you so much Sparrow you rock

Ciao Domenico,
tanto la mia era solo una curiosità nel vedere come funzionava il programma. Immagino comunque quanti aspetti bisognerà considerare in Italia.
Un abbraccio anche a te.

Hi,

In order to help you, you need to see at least an example of your Excel file.
At least one or two patients with column names. You can change the patient's first and last name to XXX, YYY.

We need to write our own procedure in this type of import file.
It's possible.
But for this I am forced to request additional information.
1. Is the patient import data stored in one file or a separate file for each patient?
2. If each patient has its own import file, how similar are the fields in the files?
3. Does each patient have a different number of drug columns?
4. Forced to ask for the ORIGINAL Excel file/files. Two or three patients are enough. You can hide personal information (first name, last name, dates, city, address) with one asterisk, it doesn’t matter. I am interested in how the table further provides information about medications for several patients and several medications for one patient.
I suspect that the file you sent has already been edited and prepared by you. Perhaps the original information is in a different form? This applies to medications.
As for your modified base. I would not include in the database fields that can be calculated when displayed in the form, such as year, month, number of days, total cost of the medicine.
The year, month, and number of days are not contained in the import file, but the diagnosis is superfluous in the import table.

Thanks for answers. If I need additional information I will write. No questions yet. There is a solution to your question, but it will take me a little more time to implement it in the procedure. Sorry force majeure. I hope to finish it by Monday.