[Qgis-user] One-to-many Spatial View in Spatialite. Attribute table doesn't show records as desired

[Bernd Vogelgesang]

Hi there,

I have a polygon layer with an id and a table with multiple species 
observations on that same id(area) in spatialite
I managed to create a spatial view and load it within QGIS.

When I use the identification tool on a polygon, all species 
observations show up correctly in the info tool window, but for browsing 
these informations, this is not really the best representation.

The attribute table on the other hand would be much better to read the 
infos, but here, all species entries connected with one feature are 
replaced by the first species data only (e.g.  instead of 25 different 
birds, it shows one entry 25 times.

Is this a bug or a feature or are there other tricks to get tabular data 
of all those entries i can see with the identification tool?

The goal is to get a way for a collegue to select a polygon, and 
immedately see all species found there in a tabular form.

Thanx for any help or hint
Bernd