<html><head></head><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:16px"><div id="yui_3_16_0_1_1455838277084_4347"><span id="yui_3_16_0_1_1455838277084_4418"></span></div><div class="qtdSeparateBR" id="yui_3_16_0_1_1455838277084_4051">Firstly, thanks to those who already helped me with this.</div><div class="qtdSeparateBR" id="yui_3_16_0_1_1455838277084_4051"><br></div><div class="qtdSeparateBR" id="yui_3_16_0_1_1455838277084_4051">I have established a relation between non-spatial catch records in a postgis table and a table of station information (linked via foreign key).</div><div class="qtdSeparateBR" id="yui_3_16_0_1_1455838277084_4051"><br></div><div class="qtdSeparateBR" id="yui_3_16_0_1_1455838277084_4051" dir="ltr">If I click on a station with the info tool, I can see the various catch records from that station - so the relation is working.</div><div class="qtdSeparateBR" id="yui_3_16_0_1_1455838277084_4051" dir="ltr"><br></div><div class="qtdSeparateBR" id="yui_3_16_0_1_1455838277084_4051" dir="ltr">But that seems to be it. If I filter on the species in the catch, that only applies to the catch data showing up when I select a station - it does NOT hide stations where that species was not caught. I cannot change symbology based on a relation, I cannot select features based on a relation - all I can do is view the records - and with 70 fields in the station layer, the catch records are just a small window at the bottom of the form.</div><div class="qtdSeparateBR" id="yui_3_16_0_1_1455838277084_4051" dir="ltr"><br></div><div class="qtdSeparateBR" id="yui_3_16_0_1_1455838277084_4051" dir="ltr">It seems that to be useful I need to create the view or table in the database & access this with QGIS - whioch has issues for users without create access in the database - which is most of them.</div><div class="qtdSeparateBR" id="yui_3_16_0_1_1455838277084_4051" dir="ltr"><br></div><div class="qtdSeparateBR" id="yui_3_16_0_1_1455838277084_4051" dir="ltr">Is work on this area (relations) of QGIS actively ongoing, or should I look for non-QGIS approaches?</div><div class="qtdSeparateBR" id="yui_3_16_0_1_1455838277084_4051" dir="ltr"><br></div><div class="qtdSeparateBR" id="yui_3_16_0_1_1455838277084_4051" dir="ltr">Thanks,</div><div class="qtdSeparateBR" id="yui_3_16_0_1_1455838277084_4051" dir="ltr"><br></div><div class="qtdSeparateBR" id="yui_3_16_0_1_1455838277084_4051" dir="ltr"> Brent Wood</div><div class="qtdSeparateBR" id="yui_3_16_0_1_1455838277084_4051"><br></div><div class="qtdSeparateBR" id="yui_3_16_0_1_1455838277084_4051"><br></div></div></body></html>