I have two tables with n number of columns out of which mobile number, plan, and amount are common in both tables, we are getting data into tables from two different locations, now i would like to show plan and amount from two tables for which mobile number is same and to be shown in same grid, Can we do this simply without using complex logics and local variables
Discussion posts and replies are publicly visible
Sure, use synced records and create a one-to-one relationship. Then you can easily show all data in one grid.
I opened summary view by clicking on mobile number for a particular record, In the summary view I should show plan and amount columns with all the rows present in the both the tables with same mobile number