Multi tiered table -> table -> feture selection with relates

Discussion created by JonHak on Dec 22, 2010
Latest reply on Dec 23, 2010 by csny490
Sorry for the crossposting, this is more of a geoprocess done in Python question.

I used to do this all the time in AML and I would think it should be a little clearer in ArcGIS. I have process I want to automate in Python where I select a record in one table using Cursors (this part is easy I do it all the time), I want to then select the records in another table that match values defined in the cursor table (I think I have this done with TableSelect_analysis) and finally I want to select feature records in a layer via a relate to the 2nd table (this is where I'm stumped). I have my relates predefined in my file geodatabase and the work fine in ArcMap, but I want to automate the process, can someone point me to example python script that imitates and uses relates from a table to a feature?