Perhaps I am misremembering, but I thought that when you joined a table and then calculated a value from the joined table into the input table, the table name was only attached to the joined field names.
ie
FeatureID = join_table.FeatureID.
I'm finding that in a model, the input field also has a table name attached to it and that is making it very difficult to automate the process, because the input table will have different names.
input_table.FeatureID = join_table.FeatureID
Is there a setting or a way I can get the model to just recognize the input table fields without a prefix? I create a temporary join table with the same name every time, so the join table fields have a consistent name, but I would like to preserve flexibility on which input table is used.
Thank you,
Randy McGregor
