Hello,

Until recently, I've been using QGIS to do basic mapping/analysis tasks, nothing that ever required a geodatabase or any relates. My company just subscribed to ArcGIS online in the hopes of building a webmap/webapp to help identify areas where there are pesticide use restrictions based on legal injunctions and fed/state/local regulations. The goal is to build a webmap that displays a popup showing the pesticides that are restricted and the basis for the restriction for any object that is selected.

To start, I have a file geodatabase containing a table of all of the pesticides subject to restrictions (tbl_pesticides with 189 records) , a table of the basis' for the restriction (tbl_basis with 4 records), and a feature class (pesticide_use_restriction_areas) that contains all of the geographic areas (polygons) where a use restriction may apply (identified by a field "BASIS") along with a bunch of other attributes for that object (area, county, PLSS info, etc).

Can anyone help me wrap my head around how to relate this all? A "basis" can have many pesticides (for example, there are 7 pesticides restricted in groundwater protection areas) and a pesticide may be related to multiple basis' (for example, simazine is restricted in Groundwater Protection Areas and in Red-legged frog habitat). In my head, I assume that the field "BASIS" in the feature class would be the primary key on which to match to the field BASIS in tbl_basis. But, how to I relate tbl_pesticide in?

Do I need an intermediary table, something like tbl_pesticidesbybasis with two fields (BASIS, PESTICIDES) where each record is unique, but the table might look like:

​

I tried something like this, and still could not get things working as expected. Any guidance on this is greatly appreciated.

Thanks!