Recent content by jaco8867

Sharepoint generally is backended with MS SQL server, and FM has connections for MS SQL server.

Try opening a new window, then go to your layout. Copy then close the window and you will still be in your original field. Hope that helps

You could try Leftwords/RightWords/Middlewords functions to separate.

Have you tried a case statement? Works better than nesting IF statements.

Place a shortcut to the database files (or folder they are located in) in the FM Server directory. Then when FM Server starts up, it will automatically open this databases. Hope that Helps John

One way would in your script Set Error Capture [On] Perform Find[] If [Get(LastError)=401] Perform Script [Script 2] exit script end if 401 is the error code when no records match the request. Hope That Helps John

Try using a script like this Go to Record/Request/Page [First] Loop Set Field [CombinedField,Field1 &" "& Field2 &" "& Field3] Go to Record/Request/Page [Next, Exit after Last] End Loop After running the script, you can then delete the old fields. Hope That Helps John

You have to drag the Set Field script step from the left hand window into the main (Right Large) window. This will add the Set Field Step, then click on options in the lower right hand corner, and add the field and the result.

Your IF statement needs to be like this If(jobType = "production") Set Field("costOfJob","45.00") End If The Then part is on the line(s) between the If and the End If steps. Hope that helps John

To achieve what you want. Create a value list that uses the values from the field in question. Then on the field in layout mode choose format - field format and change the field from a standard field to a pop-up list and use the value list you created. Note: Filemaker dosen't do a "Type Ahead"...

Try using DayOfYear instead of Day function John

Control-Click on the file and choose Get Info. Change permissions to read & write.

Ok, so assuming the issue must be with the server. Check your authentication between FMS7 and Web Server? You might try removing then reconnecting the authentication between the two. Did you install FileMaker Server 7 Advanced 7.0v3, Web Publishing Update? Are you using SSL?

You might want to try sharing it on just FMP7 client, and verify you can access it this way. You will not be able to check the external accounts, but you could check filemaker accounts. This would tell you if your problem is with the account setup or with your server setup.

Did you specify which users have access to the database via IWP? you need to give access to the file under "Instant Web Publishing access to file". Which is located in the lower right hand corner of the Instant Web Publishing dialog box. (Sharing \ Instant Web Publishing) Hope that Helps