GuruDrew

Create 2 global text fields. One is SILVER Matcher and the other GOLD Matcher, make sure in your opening script you set the value of the globals to SILVER and GOLD respectively. Then make two self join relationship to your contacts table, one on Contacts::GOLD Matcher to Contacts::Contact Type and the other self join relationship on Contacts::SILVER Matcher to Contacts::Contact Type. Next put a tab control on your Contacts layout. In one tab place a portal on the Gold TO and the other tab place a portal on the Silver TO. HTH P.S. Welcome to the forum!

Make a self join relationship from your Assignments table from BothInstruments field to BothInstruments field. Call the new TO UsedInstruments. Then in the Assignments table put the following validation calculation on the Instrument1 field: If ( Position ( Evaluate ( Instrument1 ) ; List ( UsedInstruments::BothInstruments ) ; 1; 1) > 0 ; 0 ; 1 ) Instrument2 field validation is much the same, just change Instrument1 field to Instrument2. You can then pop up a nice message saying who the student is. Allowing override on the validation should give you just what you want.

Make a field in the Assignments table called BothInstruments. Make it an autoenter calculation of Instrument 1 field and carriage return and Instrument 2 (Instrument1 & ¶ & Instrument2 ). Allow it to replace existing value. Then relate Instruments to Assignments on Instruments::Serial Number to Assignments::BothInstruments only. You'll have to replace the new BothInstruments field in the assignments table with the same calculation to get historical data up to date.

WPE was working fine until a power outage killed the server unexpectedly. After restarting, the database server works fine, but WPE acts as if it is starting, then after a few minutes dies. Running the server deployment picks up that IIS is installed, but fails on the last step of configuring with the .jpg error message attached. I've checked the Windows Logs but they don't contain any WPE errors. I've double checked enabled anonymous access in IIS with the user account IUSR_FRANSCORPSERVER. I have restarted IIS services, and cleared the Java cache but to no avail. I can see the default IIS web page from all computers on my network so I think IIS is working fine. I've attached the log files that reside in C:Program FilesFileMakerFileMaker ServerWeb Publishingpublishing-enginecwpe-tomcatlogs as well as C:Program FilesFileMakerFileMaker ServerLogs. I am guessing that some file has got stuck in a cache somewhere, I'm just not sure where or how to flush it. Thanks in advance for any ideas!!! P.S. am using Windows Server 2003 SP2 with Filemaker Server Advanced 9.0.3.325 Logs.zip

Driven by my need to NOT have to re-build my database I did some experimenting. Thanks Fitch, you seem to have cracked it. I had given my project a name as follows... "My Project v1.0.fp7". Either the get(filename) statement or zippScript was dropping the .0 in the filename hence why it worked on the remotely logged in computer but not the host. Taking the version numbers out of the filename fixed the issue

K, now I'm embarrased! I created a new database that mimicked the action I wanted and it worked. So I ran the recover action on the problem project, tested the zippScript functionality that I wanted and it worked. Seems like I got a whole lot of work to do to re-builed the project! Thanks guys for your time to reply.

Ahoi! I recently made a project which utilises zippScript 2.2. It works well with Windows XP SP2 as well as MAC OS X, whilst hosted by Filemaker server. If I try to use the database locally on my computer, then zippScript doesn't work. If I get another client to connect to the shared database on my computer then the plug-in functions correctly on the client computer, but not the host computer. Any ideas on how to get zippScript working with a single user .fp7? GuruDrew