Hi Readers,
I have two tables
Table-A with columns:- ID_A, Job_Role, Company_NameTable-B with columns:- Member_ID, Name, PhoneNumber, ID_A
which are related as one to many relations
I have created record type for different these tables and added relation ships in the record type as well, Would like to know can we consolidate them as below requirement
rows which i want to display are
Below are the tables structure
Table-A is as below
Table - B is as below
Discussion posts and replies are publicly visible
Since the grid you're looking for has one row per member, I'd suggest making the record type for table B your source for the grid. Then, you can reference fields from table a by using relationship references. For example, you can select the job role by referencing the field recordType!A.relationships.B.jobRole.
If you're still having troubles, can you post your code and any errors / issues that are occurring?