Jump to content

Archived

This topic is now archived and is closed to further replies.

tyler

Symlink fields in a table?

Recommended Posts

I have 3 tables,

 

table1

table2

table3

 

They all have the same field;

 

field1

field1

field1

 

Therefore, when anything gets changed in field1, it needs to update it 3 times. Is there a way to symlink the fields in the other 2 tables so it just looks at table1\'s field1 for the other 2 tables?

 

Thanks,

-t

Share this post


Link to post
Share on other sites

That\'s precisely the reason why data should be held in one place and not duplicated across tables. The only things that should be duplicated are (non-changing) key references for joining tables.

 

What is the structure of your 3 tables?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.