Summary Field and Multiple Users
If I had a solution that was being shared among several users, lets use a very simple example of a customers database. Say the file had only one table with 4 fields in it, CustomerID (an autoenter serial), Name, Phone, and a summary field called TotalCustomers. The Summary field was a count of CustomerID. Assuming that the current found set contained all the records, and was the same on all the users logged in to the database, TotalCustomers would show the number of records in the file. If one user created a new record, at what point would TotalCustomers be updated for the other users?