Skip to main content
January 14, 2021
Question

Display Value from two tables in Interface

  • January 14, 2021
  • 6 replies
  • 0 views

Hello All, I have 2 table, All fields from Table2 automatically populated from Table1  but if any changes made in Table2 fields the data should Display in Table2. Can Anyone help me with? Thanks in Advance

6 replies

shikhat0003
January 15, 2021

Can you elaborate a bit more on the use case, along with the table structure?

January 16, 2021

Hello Shikha, Thankyou for Reply.

Table1 is Parent table and Table2 is a Child with Parent to child(Cascade All ) Relationship

Table1 is a Lead Table(User fills the form) with Details

{

Name, Email Id, Phone No, Address, Date From and Date To, Adults

};

After Submission Agent Manager receives full data which has to appear in Table2, I have used Milestone(Bar) Pattern in Interface.

In 1st Milestone I am showing User Form with all Disabled fields.

In 2nd Milestone I am showing Customer Details with Editable Fields. 

{

Name, Email id, Address and Phone Number

},

Now, Problem is If Manager wants to edit the Data in Customer Details in Milestone2 the new data should display in the particular field and the new data should save to the Customer table and if changes not made previous data should saved to the table.

Can you help me to solve the issue

shikhat0003
January 16, 2021

Are you writing the values to DB anywhere ? Can you please post the code here ? (insert -> insert code )