Creating Reports

[breicher]

I'm running FM6 for a computer inventory database. I want to be able to somehow create reports that can tell me how many PCs are in building X, how many have a X CPU, or X RAM.

I assume this can be done but don't know where to begin doing it. Can someone point me in the correct direction?

Thanks,

Brad

[-Queue-]

If there is only one file involved, you need three self-relationships: one from buildingID to itself, one from cpuID to itself, and one from ramID to itself. Then you create calculation fields of Count(relationship::serial). If there are multiple files involved, you'll need relationships between them, similar to those above, appropriate to each file, with Count calculations in those files.

[breicher]

I've got multiple files involved. One for PC, one for monitors, 1 for rooms. Where would I create the relationship and count fields?

Thanks,

Brad