I have a polygon layer of planning applications and I am wondering if anyone can give any advice and or has seen or written a blog post that might point me in the direction of creating relationships between polygons that exist wholly within other polygons using QGIS. For example placing the parent ID in a field of the child records based on a polygon being wholly within the parent polygon.
I am thinking that I might be able to do something like convert the polygon file to centroids and then analyse the resulting points to identify inclusion within the former polygon table.
As it stands the polygon / planning application layer is one single table so the ideal procedure would actually analyse bigger and smaller polygons within the same table rather than between a duplicate table but that procedure may not exist.
The final objective is to create planning application histories for sites.