Jump to content
Vishnu Yanala

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.

 

Share this post


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.

Share this post


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.

Share this post


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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

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