ikmattie

These are the two scripts I'm talking about, Script one: If[isEmpty ( Post-op Evaluation::${Study-ID} )] Copy [select; Study::Study-ID] Set Field [Post-op Evaluation::Study-ID] Perform Script["script 2"from file: "Post-op Evaluation"] End if Go To related Record [lot of text, but it's working] Script 2: New record/Request Go to Layout["Post-op Evaluation"(Post-op Evaluation)] set field [Post-op Evaluation::Timpepoint; 1.5] Paste [select; No style; Post-op Evaluation::Study_ID] Script 2 stops at the last line, concluding in not going back to script one and that filemaker hasn't finished making the record yet (when I perform the scipt again (from file 1) he makes another record in file 2, which I don't want. Only when I make sure the record is made in file 2 (actively press 'something'), and I perform the script from file 1, he goes to the lay-out in file 2 (the script will now not perform the stuff between "If" and "End If"

I had a database in FM6, converted now to 7. There's a script in it where, somewhere in the middle another script is called in another database. Problem is that it seems that filemaker doesn't want to return to the original script, but keeps 'hanging' at the last line of the other script.

That's it, thanks!

Having a look at it later it seems not to be working, the filemaker help says it should give you the number of found records, it did, but now I gave FM antoher find-request, it shows the old number of found records, and that's not what I want

Perfect! CurrentFoundCount does the job!

On my lay-out, I want a field which represents the number of found records, so when people who are browsing know at which record they are (current record, that is possible, I know) and how many records there are left to do. It's the same as in the status-area, I know, but when other people are using my database, I wanna get rid of the status area.

Strange: After he converted my FMpro6 file (with password) I cannot open the new FMpro7 file. FM7 is asking for a password, and I don't know which one.... The old one is not working.

What is the best way to make a new record in another database? I want to make a button, resulting in first checking if the record doesn't allready exist, if no: copying the contents of a field from database A into a field in Database B, creating a new (related) record.

I made a database with a lot of pictures, now I want to put a part of it on CD. When I select the records which I don't need and delete them, the database doesn't get any smaller, because it's not checking for unused blocks.. Why not? When I make the db completely empty it is checking for unused blocks and the size decreases dramatically...

I have now tried it on 2 different computers, but it's still not working: When I want Excel to make Pivottables from filemaker data, it won't work! Before it did work, and still with other tables it works, but not with the one I want to work on now! In Excel I get an error message " [color:"purple"]Database not open. Cannot open table:name of table ." I'm very sure the table is open, so that's not the problem...

When I'm filling in my records I go from program to program to gather information. As i'm doing this i'm clicking a lot, sometimes in combination with scrolling with the mouse wheel (accidentely most of the times) when this happens in filemakers, he jumps to the next (or previous) record. For some peoply this might be handy, but for me not, it happened a few times now that I filled in fields in the wrong record...... Is there a way to turn of this feature? (I don't know if I'm in the right forum now.....)

I'm normally using FMpro 5.5 on a Windows based computer. ODBC and Sybase implementation is working perfect on this combo. But now we want to have our Macs also gather information from the sybase databasesource, how do I get this working on a Mac? (it seems that some drivers etc are not installed/active on the Mac, but I can't find them) I'm not very familiar with Mac OS9, so that might be the problem..... (I've searched the Internet and FMforums, but couldn't find the exact answer to my question )

Hi, After linking a picture into my database I get an icon and not the data itself. OLE doesn't seem to work. Anybody any ideas ? Thanks,

and make sure you have your "" and () at the correct places, else you will end up in a continuos loop... exit loop if["Status(CurrentFieldname) = "fieldname""]

I have a script with a loop, and I want to exit the loop when I 'arrive' in a certain field. I think it's quite simple, but since I'm a newbie, I couldn't find it. [ April 11, 2002, 05:04 AM: Message edited by: ikmattie ]