If you have a table which simply has a list of Department codes then you can add that table and the left join all other data off that table.
Make sure your dept group uses field from that table.
You will then always get a list of departments irrespective of whether there is data or not.
Ian
Add comment