View all Parent records and related Child records in single table view
I am looking for a way to view, in table format, all Parent records AND any related Child records. I understand that some of the data displayed will be repetitive, but that is okay. If I create the new "table view" from the Child, then only those Parents will show where there is a connection. And my only option from the Parent side, is to create Summary fields, but I don't want a summary, I want to see all the records.
Part of this effort is to see which Parents don't have certain Children. I think I could create a report or table that would just display this information, but I'd like to see it in relation to all the Children records. My work around for now has been to export the entire Parent table and Child table into Excel and manually match Parents up with Children so that I can see all the relationships and even those without a relationship.
Just seeking a more automated or programable option as manually is not a quick process.
------------------------------
Ember
------------------------------
All works now. The formula I was using was modified as I assumed that the formula shown below (which you previously provided) that the var text CombinedText = was a placeholder and didn't need to be inserted into the formula field. When I left that part out, the editor didn't like the semicolon after the first line so I modified it till it "liked" my formula. Thus getting a partial result. I used your formula as is and only replaced the "My Text Concatenation Field" for my actual field name.
var text CombinedText = ToText([My Text Concatenation Field]);
// substitute new line for semicolon
SearchAndReplace($CombinedText," ; ","\n")Thank you for your assistance.
------------------------------
Ember
------------------------------