I want to create 2 tables with 1 mirroring another. So in table 1 when I create a record and enter a value in the field, I want table 2 to automatically create a record with the same value in it's field. I would then want to add other fields that are unique to each. I'm thinking that this would be a calculation.
Any help would be greatly appreciated!