AnsweredAssumed Answered

Creating Reports with records that have multiple data per field

Question asked by RobWood on Jul 11, 2012
Latest reply on Jul 11, 2012 by philmodjunk

Title

Creating Reports with records that have multiple data per field

Post

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.

Screen_shot_2012-07-11_at_11.46.59_AM.png

Outcomes