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?
I am having a little trouble discerning exactly what you are attempting to accomplish and wouldn't want to lead you in the wrong direction. If you would like to call our Support line at 800-673-3302 we would be more than happy to field your questions and assist you with reaching the intended end result.