ok i did use a auto-enter calculation. where is the filed calculation? i am not familiar with those
Field data types such as Calculation, number, date, text, etc are selected from the Type drop down located to the right of the Field Name text box found at the bottom of Manage | Database | Fields.
I have used this method for years and it works much better than having to go to a layout where the field exists, showing all records and using Replace Field Contents.
One caveat ... be sure and NOT go to Storage Options (once you have made it a calculation) and do NOT check 'do not store calculation results'. If you do, you will lose all of your real data values (if any). It would not matter in this example since the results of the calculation are gathered from two different fields but if the existing field has real data (used in the calculation), you will lose it.
Always back up first. And take advantage of field indexing (which this technique depends upon) and leave the calculation indexed. If your calculation cannot be indexed ... STOP IMMEDIATELY and cancel out. So if a field has real data and the calculation simply rearranges it, switching to indexed calc and back to regular field will change all of the actual field data.
Please note: this is an old thread and won't pop up into Recent Items when you post a comment to it. And if it doesn't show in recent items, I'm not likely to spot your question.
If you need help post your questions to the thread from which you were referred to this thread or start a new one.
You're right. I just realized it wasn't what I thought it was above. It actually was because of a script trigger I created and only realized once I deleted the script trigger lol! But I recreated it and I made it work, so what I did to get the data in one table to populate in the main table and still have the ability to edit/modify the field in the main table was to create a script then choose that script as the OnObjectEnter trigger. Here is the script I created:
If [Table1Name::FieldName = Table2Name::FieldName]
Insert calculated results [select; Table1Name::FieldName]; (Table2Name::FieldName)
Exit Script 
That did it! Thanks!!