Scenario: I am given a layer of point locations called "problems." These will be displayed on a web map. Users will then use the web map interface to create and populate field information for a point layer called "solutions." The difficulty is that one problem can have many solutions, and one solution can solve many problems. The underlying database (PostGIS, in my case) must reflect this.
I have built a few, simple web applications before (including some that allow simple user editing/feature-creation), but I would still classify my experience level with application-development as fairly novice. I am using PostGIS as my database, and I would like to implement the front-end in either Geo-Ext, the OpenGeo Client SDK, or using GeoDjango, but can't figure out how to do it. Any advice?
I am new to this forum, as well. If I can do anything to enhance the quality or clarify the purpose of this post, please let me know.