FM 16 Adv - Relationship

Discussion created by synergy46 on Nov 9, 2017
Latest reply on Nov 14, 2017 by jormond

I have tried several variations, including using a join table, and have not been able to create a report that has the contents of different tables in the [body].




Because the Awards table, for example, can have anywhere from 0 to 75 awards, using a portal makes the browse display look ugly when NOT in Print Preview.


I suppose I could bite the bullet and learn SQL?  And, I don't mind doing that if some of you FM experts advice me that is the way to go.


Thanks for reading and replying...