arctested

how can I get the joined table field name to query the layer,after layer,table joined

Discussion created by arctested on Jun 18, 2013
Latest reply on Jun 18, 2013 by agray1
Hi,

I am able to programmatically  join a layer and a table, the way suggest at "http://help.arcgis.com/en/sdk/10.0/vba_desktop/conceptualhelp/index.html#/How_to_join_a_table_to_a_layer_in_ArcMap/00010000008t000000/".

I need to now programatically get only the rows that were joined. or the count of the rows only joined. ie. if the layer had a "CITYID" field  joined to "CID" field of the table. may be only 10 rows had the same "CITYID" as the table.

or how can I refer the "CID" after the join in the where clause of the layer query. If I use

featurePin.Fields.FindField("CITY.CID") it returns '-1' ie. the cfield does not exists.

how can I get the joined table field name  to query the layer, after the layer and table were join
ed programmatically(VBA)?

Thanks.

Outcomes