Hello,
there is a functionality I need to implement in my database and I don't have a clue how to do it.
The problem :
In one form I select search parameters and from there, I can start a search. Now the problem, I need another form to open up and display the search/query results in a table ( records in rows, data fields in columns ). Besides the results table, the form should contain controls to set up sorting of results. For example, if I click "sort by name", the results in the table should re-sort.
Also, I should be able to activate/deactivate certain data fields in the results table ( by checking/unchecking certain check boxes ), on runtime.
Primarily, I don't know how to set up such a table in a form that contains query results. The query itself is not the problem, just SQL... but the table and sorting and such...
I would be glad to get any hint, thanks in advance!
Victor
there is a functionality I need to implement in my database and I don't have a clue how to do it.
The problem :
In one form I select search parameters and from there, I can start a search. Now the problem, I need another form to open up and display the search/query results in a table ( records in rows, data fields in columns ). Besides the results table, the form should contain controls to set up sorting of results. For example, if I click "sort by name", the results in the table should re-sort.
Also, I should be able to activate/deactivate certain data fields in the results table ( by checking/unchecking certain check boxes ), on runtime.
Primarily, I don't know how to set up such a table in a form that contains query results. The query itself is not the problem, just SQL... but the table and sorting and such...
I would be glad to get any hint, thanks in advance!
Victor
