TDBGrid questions

[xinyiman]

Hello, I wanted to know if a date TDBGrid you can apply filters on data natively as it does on access to grids. Or if there is already an object that does something like that. For example right column filter "value".

Another thing I wanted to understand is:

I have two tables, the table workers and the work table.
Each work table has a field that matches the ID of the work you do. How do I ensure that I can change that by TDBGrid? Making it appear as if it were a combobox?! Thanks for your help

[xinyiman]

Edit message up

[xinyiman]

Wanting to simulate the filter access with my item if necessary, how can I not show TDBGrid in a row in the query? Without changing the query. And hopefully you can sort a column in a TDBGrid to my liking? If you like? help me please.

[xinyiman]

Why in the example I have attached I can not enter data, or rather, I insert the data, then press SALVA and close the program will re-open I do not find the data.

[xinyiman]

anyone who can help me?

[xinyiman]

Does anyone know of an example where we see a record entry directly from TDBGrid? thanks