PsyberDave

Thanks. So I do have Advanced. It seems odd to me that FileMaker didn't label the programs.

OK, simple question here. I just downloaded and installed FMSA 10. Or, at least I think I did. I purchased several items from FM and downloaded what was labeled to be FileMaker Server 10 Advanced, but the software doesn't say "Advanced" anywhere on any screen, not even in the About box. It does show a maximum connections of 999, so that seems like the Advanced version. Is the software not labeled "Advanced"?

I can confirm seedwest's suggestion. I used the setup program in the Files folder and installation went smoothly from there. I am a little disturbed that the installation didn't work in a straightforward manner.

Right you are. My script sets the Students::UserGlobal field with Get(AccountName). The Students::UserGlobal field is linked to the Users table (Students::UserGlobal to Users::User) where there is a matching record containing an Ocode. That is how the privilege calculation can check the Students:Ocode against the Users::Ocode. You have me thinking...Should I put the user's Ocode in a global field in the Students table (say, UserOcodeGlobal)and then check the Students::Ocode against Students::UserOcodeGlobal?

For the most part, my database is running well, but ocassionally I get calls from my users that they aren't seeing all of the records they are supposed to. I have found something that fixes the problem, but the fix is temporary and the problem returns the next day or a few days later. The database has a table of students and a related table of mentors. There is also a User table that contains which office each user belongs to. Each student and mentor record contains a code identifying which office they belong to. Permissions are set so that users can only view student and mentor records that belong to their office (e.g. for Student records, View permissions are set as Ocode = Users::Ocode or OcodeOrig = Users::Ocode where Ocode is the "office code" and OcodeOrig is the original office code for students who originally were with another office.) A script runs at log in which looks up the user's office and finds the students that belong to that office. That script is set to run with full access privileges. This all works fine for the most part, but I suspect a privileges-related problem. Sometimes my users do finds or constrain their found set and the resulting found set is smaller than expected. They may know they have 20 12th graders, but when they do a Find for 12 in the Grade field, they may get something less than all 20 of their 12th grader records. Similarly, this happens with constrain found set. As a developer with full access to all records, I don't see this problem until users call me. I have found that if I go into Define Accounts & Privileges, go into the Custom Record Privileges for the Student records (or any of the other tables that has limited viewing) and open the calculation for View (without actually making changes) and then save everything, the problem resolves. Sometimes it stays fixed for a day, but often it works for several days. Clearly, this is not a good enough fix. What might be going on? Is the issue on the server (Server 8) or might it be an indexing issue (Ocode is fully indexed in all tables that use it)?

We use Citrix to connect our users to our database. We have over 30 people connecting sometime and connection quality varies from decent (a slight lag and the occassional multi-second pause) to one of our remote offices that experiences intollerable slowness. I suspect it is a bandwidth issue at their end.

I've searched the magazine online. Do you have something specific in mind?

I am looking to implement an audit trail in my database, but I want it to be different from the standard audit trails I have seen. I need help and would greatly appreciate some assistance. Typically an audit trail is a text field with a calulation that copies changed data from other fields, concactenates those data, and appends it to previously stored data in the audit trail field. It might store data from several fields and tack on a timestamp. I don't want to store a concatenation of several fields in one audit trail field. I want to write changed data to *respective fields* in another table altogether. For example, I have a table of students. Each student record has a status field. Every time a user changes the status of the student, I want to record that change in a Status History table. Eventually I want to be able to display a history of status changes. I know it would be simple to write a script to do this, but here is the twist: I don't want to use a script. I can't. The student data are displayed to the user as a table view, with Status as one of several columns. Users can enter and exit fields quickly and they do not have to manually save changes when moving between records. They like the speed of this design. The Status field contains a dropdown list of a handful of statuses that the user can choose from. I don't want to force the user to have to click a button to save the change. They should just make their changes and move on to the next field or record, just like they do for any other field changes. I want to record the Status change transparently. Ideally, the solution would detect a change in the Status field and create a new record in a Status History table with a copy of the student's key record ID in the Status History table's Key Record field and copy the new Status to the Status field of the History Table (Of course a time stamp would go in the History Table too, but that's goes without saying). Eventually I'll want to create reports that show status changes for students during certain date ranges. This will be so much easier to do if I can do a find on a table that has discrete fields for dates and statuses and discrete records rather than attempt to tease apart a bunch of information that was mushed together in a text field. I don't know how to automatically create a new record in another table and write to it in a way that is automatic like a calculation is automatic. HELP! -)

I have a database that uses about 20 layouts. Each layout has a header section that contains links to every one of the other pages. This is akin to a webpage that has navigation links at the top. Using a website as analogy, when designing a website I can use a template that every page uses. If I add a new page or delete a page, I merely change the template and the changes propogate to all pages that use that template. Is there a comparable mechanism in FileMaker? It gets quite cumbersome to manually change the links on *every* layout if I have to make a change to the links. Cutting and pasting to each layout is still tedious (and silly, anyway). Someone remarked in another post that there may be a solution or a plugin, but I could not find the topic they were referring to.