Jump to content

Copying fields from Unrelated table


Recommended Posts

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.

 

Link to post
Share on other sites

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.

Link to post
Share on other sites

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 ?

 

Question.JPG.16cb0fe7b4e9cf59b5d6f859039b2151.JPG 

 

Thanks in advance.

Link to post
Share on other sites

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.

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.