Copying fields from Unrelated table

[Vishnu Yanala]

Hello, 

I want to know what's the value of a fields in layout A(Table:: Site_Site) and have the same value in layout B(Table::Site_Network). whenever the value is changed in one layout it should updated it self in other layout.

 

[Wim Decorte]

Typically you would not want to copy data around and have that data duplicated.  Create a relationship between Site and Network and display the value fro Site directly.

[Vishnu Yanala]

Sorry Sir, may be I didn't explained well. I have attached image for reference in which it shows two layouts. The relationship is defined with Sitekey as PK. Now my question is if the Name of the site is changed in Layout A how to update records in Layout B ? 

Can I make it automated to check for the change in the fields ?

 

 

 

Thanks in advance.

[Wim Decorte]

The screenshot doesn't provide too much extra information but in general: if you have an existing relationship between the two tables you don't need to worry about the data updating.  In layout B, just show the related fields from table A.  You don't need the same fields in table B.