EDITED: Summing and Totals in Layout

[Colm Tourque]

OK, I am a brand new newby to FM. I have used SQL, PHP, Access, ASP etc... so not knew to programming just Filemaker.

I have inherited a database in my new job and the DB looks rather complex. Part of the database allows users to log in and go straight to a page that sums their current activity and future activity.

IE

5-45 Day Cases Due

10-6 Month Cases

Here is the issue, I have a user who when they log in from THEIR machine their sums are all

0

IE

0-45 Day Cases Due

0-10 Month Cases Due

But when I log on as admin or with higher permissions I get the correct numbers. Oddly enough if I copy the database from the server and login as anyone I get all the numbers correct no matter who I log in as.

Using Filemaker 7 Server on Win Xp from a Win 2003 server.

I hope this makes sense

Edited April 17, 2006 by Guest

[Ender]

What are the calc definitions? If there are relationships involved, what are they?