Access Table

%3CLINGO-SUB%20id%3D%22lingo-sub-2120124%22%20slang%3D%22en-US%22%3EAccess%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2120124%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20is%20it%20possible%20when%20you%20add%20a%20data%20on%20(e.g%20Table1%20-%20Name1)%20then%20it%20would%20reflect%20on%20Table2%20-%20Name2%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2120124%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%20Table%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2120131%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2120131%22%20slang%3D%22en-US%22%3ELook%20into%20data%20macros.%3CBR%20%2F%3E%3CBR%20%2F%3EThat%20said%2C%20you%20shouldn't%20be%20duplicating%20such%20data.%20You%20should%20have%20it%20in%20a%20single%20table%20and%20have%20it%20related%20to%20the%20other%20table%20through%20a%20primary%2Fforeign%20key%20relationship.%3C%2FLINGO-BODY%3E
Occasional Visitor

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.