I have a (parent) table ID that was setup using a calculated field that may change value. I'd like to create an autocounter field that would have unique values and wouldn't change and then re-map the relationships. Is there a way to set a field in the child table to a calculated result, before I change the field ID for the parent table? Are parent child relationships stored else-where or am I seeing all of the available fields in the table?
Ron Whitler shared this idea · Jun 16, 2016