AnsweredAssumed Answered

Select Records on a table based on a reference table

Question asked by jack70 on Jul 31, 2012
Latest reply on Aug 3, 2012 by clthompson

I have two tables, an EVENTS table and a RESULTS table. They have a one-to-many relationship, meaning an EVENT may have more than one RESULT, using the EVENT_ID to bind that relationship. Most often I'm required to come up with a report of a particular event to include its results. Right now I have to go through a process to get the job done using both ArcGIS and Excel.

My question is, is there a python script that allows the user to select results from the RESULTS table, based on the EVENT_ID of the events chosen from the EVENTS table. I've attached sample tables for reference.

I hope you can help me...Thanks in advance...