Forum Discussion
ChuckGrigsby
8 years agoQrew Cadet
If you have 3 tables you must have at least 2 relationships.
Just by default from those relationships you can create a report on the parent table and add the related child field which will give you a link/count of related records for that table, then same thing for the 3rd table.
Or you can create a reverse relationship to bring up child record values to the parent level for all the fields you want, and then add those.
If you're ok with custom script, that would be the easiest way since you can just query without creating relationships. If you want custom script help you can contact me directly. chuck@chuck.support
Just by default from those relationships you can create a report on the parent table and add the related child field which will give you a link/count of related records for that table, then same thing for the 3rd table.
Or you can create a reverse relationship to bring up child record values to the parent level for all the fields you want, and then add those.
If you're ok with custom script, that would be the easiest way since you can just query without creating relationships. If you want custom script help you can contact me directly. chuck@chuck.support
- JimHarrison8 years agoQrew ChampionI appreciate the help Chuck. Looks like I will be needing to learn the Custom Script bit.