I have been looking at Data macros and I am not sure if it will work for me.
I have the same field in two separate tables. I know that is bad database design but these are fields actually in two separate databases and I am using links to have them end up in the same table.
When the field is updated in one table I would like it to be automatically updated in the other table. I was hoping that a Data Macro would work but it doesn't appear to let me assign it to a particular field.
If that won't work, I am looking for any way I can to auto update that field. I had a thought that maybe I could bring it up on another form and update it and then use and after update on the form.
Any ideas would be appreciated.
Thanks