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
Yes. That is possible. In a local variable, you the query record type and use the output in the grid. You will be able to access the related fields of the record by accessing its relationships. ie. recordType!Member.relationships.relatedRecord.fields.fieldName