I have a company table A and a company personnel table A with a link field. After new companies or new personnel have been entered into this table, I would like to have the same content be in company table B and company personnel table B. The fields in the tables have common names except company A starts with L, and company B starts with S. Having slightly different names stops me from just copying both A tables into B tables after updating A
As I am doing a lot of processing downstream I would like a solution that allows me to duplicate what I have in both table A's into both table B's. Any or all ideas would be welcome. Thank-you