I'm not sure how to do this as I don't' think there are any ModelBuilder tools for this task. I'm not real savvy with Python but basically I want to relate field1 in table A to field2 in table B with a one to many relationship. So I want all records in table B that match Table A.

2 Answers 2


The Add Join (Data Management) tool

Joins a layer to another layer or table (where layer is a feature layer, table view, or raster layer with a raster attribute table) based on a common field.

This can be used in ModelBuilder and supports both one-to-one and many-to-one - if you need one-to-many you should be able to reverse the order of your inputs.

  • Hi PolyGeo, thank you for the response. I should mention that I want a relate because I want to account for one to many relationships. I don't believe a join will do this?
    – Steve
    Commented Dec 23, 2013 at 21:35
  • Done, sorry I should have been clear about that stipulation.
    – Steve
    Commented Dec 23, 2013 at 21:43

"Map Rantala" came up with this when Trying to perform “relate” in Model Builder. It uses the Make Table tool to perform a relate like operation.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.