Help with Calculations
I'm working with an existing databse that has staff names and room numbers. Simplified, it looks like this:
What I would like to do is to make a "room report" that lists all the rooms, how many people occupy each room and who the people are that occupy a particular room.
Something like this:
|1||3||John, Mary, Fred|
Could someone point me in the right direction? I've had limited experience with Filemaker Pro but extensive experience with Excel.
I've worked out how to add fileds that do calculations but am unsure where to go from here.