How to display a sub set of records in a catalog

As it is not possible to display SQL VIEWS in catalogs or lists (AFAIK) how can I display a subset of records from a link?

By example, my table consists of `ID`, `Company_Name`,'category`

I'd like a set of links on a page prompting the user to select a category (button). Clicking the button would then display a catalog of records belonging to the respective category.

Thanks

Of course It is possible to display sql views.
Just take the name of the view instead of a table as joodb maintable.

But you would not be able to add or edit such entries.

Mysql Views do not have auto-increment indexes!

dirk wrote: Of course It is possible to display sql views.
Just take the name of the view instead of a table as joodb maintable.

But you would not be able to add or edit such entries.

Mysql Views do not have auto-increment indexes!

I think we had this discussion a couple of years ago, Dirk.

If I do that I cannot get past the second step (See attachment)

But maybe I misunderstand. Is there another way to create a catalog from a SQL view