PB@FBC Palo Alto

I'm grateful for numerous helpful suggestions. I was indeed trying to follow advice on page 18 of Kachel's "White Paper for FM Novices." I now have a version that works (correctly!). I don't understand why my first way failed and what seemed to me a logically equivalent substitute works. Apparently what made the difference was whether the script that contained the statement was in file A or in file B. I have two files, A and B. I wanted a script in A to write several new records in B, each linked to a single originating record in A. People suggested several different ways of passing the key value for the link, all of which seem valid. My initial attempts to use any of them all failed, apparently over a different issue. I used a script in file A which used the statement: [color:blue]Set Field (B::RecNumFromA; A::GlobalRecNum) [color:red]Target field of the new record remained blank But when instead my script in A invoked the same action by way of a script in B, things worked. Thus: Statement in A's script: [color:blue]Perform Script ["WriteTheData" from file: "B"] Statement in B's script "WriteTheData": [color:blue]Set Field (B::RecNumFromA; A::GlobalRecNum) -- then everything worked as desired. In short, in seemed to depend on whether that statement was part of a script in file A or of a script in file B.

I'm grateful for suggestions from BruceR and jmormond. Each of you provided steps that seem simple and easy to do. Nevertheless, I'm still failing. Somewhere I must be missing a key point. I readily get file A to create a new blank record in file B. (Or a Table defined in A so that it contains a view of B.) But I still haven't managed to create the value that links the newly created record in B to the current record in file A. While A is linked to B by way of the field "RecordNumberFromA" . [color:blue]Set Field [TableB::RecordNumberFromA; $ID] doesn't produce an error message, but nevertheless leaves the field blank (even though $ID has been set correctly). I thought "Well, if my new record starts with a blank in the match field, how can FM know in what record it's supposed to write $ID ??" So I created (within A) a tables that is a view of file A and another that is a view of file B, but did NOT link them. Then, trying to write into B's field RecordNumberFromA fails, I get the message "This operation could not be completed because the target is not part of a related table." OK, when they're not related, I can't write. But when they _are_ related, how do I set the value in B's new record that will relate it to he current record in A? Is it possible some other issue is preventing writing into the new record? If you'd care to suggest a text in which I could look for more discussion, I'd appreciate that too.

Apologies if this is obvious to everyone else but me... I have two files, A and B. (Each is an .fp7 file.) In file A, each record has a unique record number. For each record in A, there may be one or more corresponding records in B. B has a field "RecordNumberFromA" I want a script in A to do the following: For the current record in A, create 1 or more new records in B. In each new record thus created in B, I need the field "RecordNumberFromA" to contain the number of the current record in A. My script in A successfully creates a new record in B, BUT the new record's field "RecordNumberFromA" is blank. (Since the field by which A and B are linked doesn't yet have a value, the script doesn't know what record in B I'm trying to set.) How is my script supposed to set that field? How can my script in A say "I'm talking about the new B record that was just created"??

I have the same problem as CaliforniaEd. And, sadly, it appears to me that the lengthy response from transpower (quoting the Help file) boils down to "You can't get there from here". I'm trying to print a phonebook of members of my organization (a church). I have a file of individuals (with their names, other data specific to them as individuals). I also have a linked file of households (with address, phone, etc). I sort the file of individuals first by location (local or remote), then by household, and within household by individual names. So the "body" records are the names, and the trailing sub-summary after names is the (one) household address that is common to all the names in that household. In the "Parts Definition" dialogs, turning off "allow part to break across page boundaries" merely prevents the trailing summary itself from being split, but does nothing to keep the trailing summary on the same page as the body that precedes it. I'm still hoping to find something equivalent to the common word-processing command "keep with preceding."

The problem with "NO ACCESS" had something to do with groups. After (re-)reading the FileMaker Pro Help on groups, I still didn't understand what had gone wrong, but the Help did convince me that I didn't need groups. After I deleted all groups, the problem went away. (If someone can point me to further explanation of groups, my education may be improved, but my immediate problem has been solved.)

Thank you, Vaughan. That was it. No scripts were defined in the file, but the Document Preferences had a check mark beside <No scripts>. Removing the check mark removed the message about "script not found."

I have a file that, open opening, always puts up an alert saying "This script cannot be found or has been deleted." (How I wish the author of that message had been willing to reveal who or what was asking for the script, or what script it was asking for.) No scripts are defined. I've found no layout with a button that invokes any script. How else can I determine what's causing this message (and fix it!)?

I once set up a read-or-append-only access to a file (in addition to a password that provided complete access). The idea was that "ordinary" users, opening the file with no password, could browse existing records or add new ones, but not edit or delete existing ones ones

Each time I launch FileMaker, my Mac starts to dial out via modem to my internet service provider. Each time, I click "CANCEL" and FileMaker continues to run just fine. I'm using FM Pro 6 stand-alone (no other users, no server) on a Mac G3 under OS 9.2. (OS 9 only because of other legacy apps that lack OS X drivers.) Question: What's making FileMaker keep trying to connect to the internet? Is this something in each file, or something in general preferences for FileMaker, or what? Problem: How can I stop it from doing that?