Workflow Advice

[BrianLeroux]

I am looking for a way to automate a process of updating a layer from a table. I have my CIS dept updating an SQL table (Claims) in my SDE database which does not have any spatial attributes. I have a feature class (Customers) which has an matching key to that table. Is there a way to create and update a Claims feature class from the joined tables? This would be something that would run every 30 minutes when the new claims data is added to the claims table. I have been experimenting with a workflow in Catlog but can't seem to come up with the right combination of tools. Any help is appreciated.

Thanks!

[MathewCoyle · Accepted solution]

I would think this could be better accomplished outside of Arc. Using some backend SQL or tableviews that runs on a schedule. If you are tied to Arc tools, you can give Join Field a try. http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//001700000065000000

[BrianLeroux]

Thanks Mathew. I did end up using a join and it seems to be working properly. I appreciate your input.