Access Table

Copper Contributor

Hi is it possible when you add a data on (e.g Table1 - Name1) then it would reflect on Table2 - Name2?

1 Reply
Look into data macros.

That said, you shouldn't be duplicating such data. You should have it in a single table and have it related to the other table through a primary/foreign key relationship.