I have a file geodatabase with three elements in it.

  1. Lighting layer (assets) consisting of point items.
  2. Inspection table (containing inspection information for those assets)
  3. Defects Table (linked to inspection table as parent/child and also need to be linked to the assets pulling in a range of data from the asset attributes)

My question is how to do this properly? I need the relationship classes set up so a defect can't exist without selecting its inspection record, and to create a defect the user must create it from an asset so it can pull in a variety of data automatically from the asset layer to auto populate some of the defect fields.

How would I go about setting up those relationship classes to give me the desired outcomes?

Work flow required would be:

  • User creates inspection record (populates data)
  • User clicks asset to create defect record, some data auto populates the rest he/she fills in.

closed as too broad by PolyGeo Sep 6 '16 at 7:10

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.