AnsweredAssumed Answered

Server problem?

Question asked by SteveKeiser on Jun 28, 2013
Latest reply on Jun 28, 2013 by bashir1102

Title

Server problem?

Your post

     I have a table occurrence that I made so I could show only active records. When I display the layout it works fine when the database is running off my hard disk. When I run the database off the server, it doesn't work right. Instead of the found records displaying only the active records, it displays the total number of inactive+active records. It shows a line in the list view for every record, but only the active records show any information on the line.

      

     Here is my setup:

     Table------------Table2

     Table:TableID = Table2:TableID AND Table:cInactive = Table2:Inactive    where cInactive is a calculation field that always returns the active value of the Inactive field.

     The layout uses the "Table" table, but each of the fields on the layout are from the "Table2" table occurrence.

     This setup works when the database is local on my hard drive, but does not work from FileMaker Server.

     Is there some server setting that will correct this problem?

Outcomes