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 can fetch from both the tables using mobile number and merge them in local variable and can show in grid I think, but is there any other simple solution using Records so that i can use default user filters and search box easily