Creating Reports with records that have multiple data per field
I am used to using Access where creating a simple query would clear this problem right up, but from what I've gotten from the FM Tutorial PDF, all you can create are reports.
I've created a report (below) that shows job locations categorized by the city. There are many jobs that have more than one proposal, statement, and/or invoice related to it through the relationships I've created, but the report is only showing one in each of those fields per job. How do I make the report show all proposals/statements/invoices connected to each job?
Also, are reports the only way to create organized information in FM? Like I said, I'm used to Access where I could create a query, for example, by simply typing out an address of a job and running it and then I could get everything in the database that's related to that address right in front of me in a report that I could print out. Is something like that possible in FM?
If you need a screenshot of my tables and their relationships, just let me know.