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

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.

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