Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×

Open other database via script

This topic is 5909 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi folks,

I'm modifying a customer's application in FMP 4.0 and am stuck on an idea that just doesn't seem to fly.

Basically I start the application by clicking on file1.fm3, on one of it's forms there is a button that calls script1 to open file2.fm3, when file2.fm3 gets closed I would like script1(file1.fm3) to do a re-lookup based on a particular field and can't seem to get it to fly...

I tried this in script1(file1.fm3)

1 - open file2.fm3

(file2.fm3 auto runs a script to display one of it's forms

that has a close-file button on it)

2 - go to a layout

3 - re-lookup, no dialog, a field

Step 1 works but the layout does not get focus, without 2

and 3 the layout does get focus

Any help would be appreciated

Link to post
Share on other sites

Hi, Marc! I haven't used scripts much, but I think I have had db's open other db's and continue with their scripts okay. All I can recommend is that you try to track the scripts as the execute to see where the problem is. Add various simple script commands at various locations in the scripts and see if they all execute correctly. Maybe specifically introduce things like ENTER BROWSE MODE and stuff, too, even if they seem to be unnecessary.

If I get a chance later and you are still stuck, I'll see if I can simulate that in FMP4 at home.


Link to post
Share on other sites

This topic is 5909 days old. Please don't post here. Open a new topic instead.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Similar Content

    • By Norbert Wells
      This may be a really amateur question... but for the life of me I can't figure out how to do a find on a text field for records that "begin with" or "start with" a specific text string whether it be part of the first word or the entire first word. I am using FM Pro 4.0 and wonder why FileMaker Inc. didn't include a way to quickly and easily perform this seemingly simple task.
      Any thoughts? (I have already searched FileMakers Tech Info Library to no avail.)
    • By Sharky K
      hi everyone,
      I have a dutch mac news site: http://mactag.cjb.net/ running on FileMaker Pro.
      My question is: can I make with Filemaker Pro a kind of message board so people can post comments on news posts?

      An other question is: Is it possible to make a search so that you must type in both search fields? (it is maby a little bit odd but i want to make that you get a kind of login/password and when you type them right you will find your own records.)
      kind regards
      Sharky K.
      [This message has been edited by Sharky K (edited June 18, 2000).]
    • By jmichea
      Not sure if this qualifies as a basic question or not but here goes...
      I am looking to do a find for an item that may appear in several different fields across multiple records. For example, I have a record with one section that contains 10 fields listing parts. I want to do a find that will find the name of the part in any or all of those 10 fields. Not sure how to do this.
    • By donwolf93
      A user was using FileMaker 3 (we use 3 and 4) on our network and tried to print and crashed so he restarted the machine. Now when I try to access the file, I get the message: "That file has been damaged or possibly had its access priviledges tampered with"
      I've tried opening it from 3 and from 4, and copying the file, and recovering the file. (Recover performs steps one and two and then reports that it cannot find the file in question)
      Any idea on how to recover this file?
      email appreciated donwolf93@hotmail.com
    • By Stan
      The username says it all...rookie.
      Working in FM4Pro, developing on a Mac and porting to PC.
      I'm trying to do a simple sign-in roster, where users enter their user ID, hit OK and are logged in, date/time stamped, and set active (an entry in Timein field). Users are stored in the employee database. New users will set up a new record (userid, firstname, lastname, and orgid) in the employee database as part of the log in. When they log out, all users just enter user ID and the program pats 'em on the bottom, says goodbye, and calculates the amount of time on. Simple.
      Except when I ported it from the Mac to the PC, it began to fall apart. F'rinstance:
      --The login screen wouldn't zoom to 75% on startup, even though the script is identical to what worked on the Mac.
      --Part way through a trial run of current users, it wouldn't log out, but kept logging them in, or vice versa (out, but not in)
      --New users weren't led to the data entry screen when they weren't found in the employee database.
      I think it's a procedural issue, but I can't put my finger on the problem.
      Printing out the scripts to check the Find parameter(s) is tedious (is there a better way?).
      The Find parameters have changed without my help, apparently on a Paste Date function. Should that happen?
      Comments invited; Thanks!!
  • Who Viewed the Topic

    4 members have viewed this topic:
    Greg Hains  doughemi  Michael Frankel  Kevin Pledger 
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.