Need help!About Tablegrid (Page 1 of 2)

Thanks much! It works well.
Another question:the year is variable,how can i do ?thaks.

Perhaps you talked about it.
The request is generated dynamically based on the number of returned values.

Hi Derek,
Thanks.

Hi,
here is your example according to the description.
A database has been created and a new procedure for rotating a table from a database has been created.
The most difficult part of your task has been created. The rest is a field for your creativity and experimentation. )

A few notes:
-You need to create a form to add / edit database records, dictionary tables (year, grade, empinfo).
-The final result in table 2 and the report is desirable to use as the final report. You may have some difficulty
editing records when trying to directly invoke a record for editing. Use table1 for testing
-The report button can be deleted. In the future, everything can be returned.
-The SQL query (script) is written on the basis that for each employee, in each year there can be only one rating.
Which means that when changing the rating in any year, the record must be edited and not a new record added.

I know there are training courses in the Russian part of the forum, but this is probably not relevant for you.
Maybe someone else can tell you.
In fact, starting with a simple one, you can study it yourself.
Training materials can be found on the forum.
Examples on the forum.
Additional SQL resources on the Internet (sqlitetutorial).
And of course questions on the forum (only specific questions) if you have not found the answer yourself.

if the structure does not change but the names of the fields change, then the names in the SQL query will change.
If the structure of the database changes, the SQL query will need to be rewritten.
The exception is REPORT where the SQL query is not needed.

Hi Unforgettable, Sparrow,
I did something a bit similar a while back (for summarising expense claims by category) but used calculated fields together with a lookup table to hold details of what it is you want to show.
The approach enables you to specify which columns to show in the grid, what column headings are displayed in the grid and the position of the columns in the grid - so it can be multi-purpose.
So, in your example, just enter your subject details (history, maths etc) into the table (in the attachment are examples for 'subjects' and for 'years'). 
The main point is that this can be done by the end user rather than having to alter any code.
Maybe it will give you some ideas (but having said that, I think Sparrow's example is technically much better).
Derek.

Hi,
If it is unlimited - or if  you have no idea how many columns you'll need, then it's not the best option for you - and why I think Sparrow's option is better because it doesn't have that restriction.
My previous attachment is based on knowing the approximate number of columns that you want to display, although using your example, I would have thought that your approximate number of subjects is known and limited.
It doesn't have to be 10 - that's just the number that I needed at the time for my expenses recording project..  You'd set it up to be as many as you think you need (and then add a few as 'spares' for contingencies;  the 'spares' don't need to be displayed (set the 'showcol' = 'No' in the summary grid and are just kept in reserve in case they're needed - see the attached screenshot)).
Derek.

Thanks!sparrow & derek!

Can you explain your project, Sparrow?

Dear derek,
               I made some modification in your project unforgettable but when data enter more and more form1 take time to load? Why it is? I want to use bar code read on form2. how it will be?

Dear derek,
               I made some modification in your project unforgettable but when data enter more and more form1 take time to load? Why it is? I want to use bar code read on form2. how it will be?