Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About SamMc

  • Rank
  1. Problem solved.I use a different set of script commands: Go to Related Record [ From table: “Parts_Used”; Using layout: “R_Parts_Used” (Parts_Used) ] [ Show only related records ] Constrain Found Set [ Specified Find Requests: Find Records; Criteria: Parts_Used:: Quantity_Used: “> 0” ] [ Restore ] Sort Records [ Specified Sort Order: Parts_Used::Part_No; ascending ] [ Restore; No dialog ] Print [ Records being browsed; All Pages; Orientation: Portrait; Paper size: 8.5" x 11" ] [ Restore ] Go to Layout [ original layout ]
  2. Hello All: I ran across another challange with my DB described in http://fmforums.com/forum/showtopic.php?tid/192648 What I am essentially trying to do is: - select a set the records from a table - based on the criteria that I get from another table for a field that relates the two, and then - further reducing the set to those records that has a quantity greater than zero. I have the following script: [i am starting this script from a button on a layout that is displaying a record from "equipment_repaired" table. ] Set Variable[$r_t_no; Value:equipment_re
  3. Soren and the rest of the folks who chimed in from time to time: I implemented the things we discussed in the forum in the production version of my DB. It is working like a charm. Many thanks again! Sam
  4. "Instead of the Perform Find/Replace, could the foreign key be an autoenter value via a $variable, which will establish the relation as soon as the found set arrives via the import." I like this idea, but i would not know how to do it while importing! Give me some hints... Maybe using "Insert Text"? Thanks! Sam
  5. - "how would the newly imported record know which records it's related when they aren't related yet.": The text "new" will only appear for the newly inported ones, which will immediately replaced by the appropriate Repair Ticket No. This will establish the relationship. - "part-numbers to be reassigned to entirely different things." Never. Actaully, in the final version of the DB I am thinking of using a different master table to look up the part name rather than importing it. I looked at your changes, thank you! Sam
  6. Well, I studied your example. Some of the things are over my head at his point, but I tried to apply some of them. The script is importing properly, but when it comes to changing the text "new" to the "Repair Ticket No" from the Equipment_Repaired table, it is failing. I am attaching a simplified version of the DB. The red button on the form that displays the portal is running the version of the script that does not work. The green button has a version of the script that just imports the parts, but does not attempt to change the text "new". I would appreciate if you can co
  7. Soren, One last thing: I am still having problems with the issue I wrote in a previous post: http://fmforums.com/forum/showpost.php?post/278619/ I would appreciate your comments. Of course, other folks can chime in as well! Sam
  8. Last question of the day: Well, I discovered that I don't have to use a loop. However, I am having difficulty with the "Replace Field Contents" script step. Here is what I am doing: - I am first performing a find on all the records that contain the word "new" in the "repair_ticket_from_main" field. - Then I am using the "Replace Field Contents" with the following parameters: . Specify Target Field: repair_ticket_from_main (in the Parts_Used table) . The other specify button below: I am choosing "Replace with calculated results" and under "Specify" for this option
  9. I figured it out. Thanks. I will now work on populating the field that establishes the relation to the main table. This I think will require a loop: - Find all new records, - Loop through each and enter the "Repair Ticket Number" to the appropriate field. This value is already on the main table. Let's see if I can figure this out. Sam
  10. Hello Soren: I just discovered that myself a few minutes ago. Will it remember the table and the field mapping when I place this script on a button? Sam
  11. Well, I looked at Soren's examples. Very useful for a beginner like myself. I also looked to see if there are any answers to my inquiry about copying from table to table. To my dismay I found out that my inquiry somehow was not posted. Here is what I want to know: On the server all my tables appear as part of a single database called "Equipment_Maintenance". I am not the server administrator but I am guessing that this is all contained in my single file that I gave to the administrator some months ago. I can see that one can import from a table that is in a single standalon
  12. Hello Soren, I asked in a different forum of import between tables is possible, and was waiting an an answer on it. Thanks for pointing out that it *is* possible. I tried to reach the link in the post you referred to but my browser could not find the computer: [color:red]-- UPDATE: Never mind, I am now able to reach dwdataconcepts! Sam Navigator can't find the server at www.dwdataconcepts.com. Is it possible for you to post the script here? Sam
  13. Thank you, Tom. Your example makes it much clearer. The number of parts in the "Parts_Template" will change over time. So I cannot use a fixed value for the condition in the "If" statement. Is there a way of either: - counting the number of records in Parts_Template and then passing this on as a variable to the if statement, or - incrementing the loop until the end of Parts_Template is reached? Sam
  14. Hello All: I know the basics of writing scripts only, and started having problems adapting a script I saw in one of the forums. Basically, what I want to do is copy from a template file a set of commonly used part numbers and part names to new records in a table. At the same time I would like to populate a field of each newly created record with a value to enable the relationship to the main table record. I'm specifically having problems with: - how to start and stop a loop, how to increment it--I am discovering that loops in FileMaker scripts does not quite resemble s
  • Create New...

Important Information

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