john9210

OK, I see your point and I will eliminate the need for duplicate data.

How can I keep two tables in sync? I have two tables, Table1 and Table2. Each table has the field Item and the number of records is the same in each table. I would like to be able to make changes in one table and have them updated in the other table so that the list of items is the same in both tables. That is, when a record is created, deleted or an item is edited it one table the other table will update to match the changes.

I finally figured it out. the end time field must be formatted as Short System Time in Inspector. I never knew what that was for before.

A simple problem: I want to add a number to a time and get the end time to express AM or PM. For example: Start time = 10:00AM Duration = 3 hours End time = should be 1:00PM I can't figure out how to make this work.

In the script pane I can't drag a folder to a new position. Any suggestion on why this is happening and how to fix it?

Thanks. That did the trick.

I’m trying to get the average value of a field on a found set. But it’s not working. Cost is a number field and I use the following script steps to get the average value. Perform Find $$Avg=Average ( BGL::Cost ) But the resulting value is incorrect. Am I missing something. I assume Average works on the found set.

I'd like to remove unused value lists. If the Database Design Report indicates that a value list does not appear on any layout does that mean it is not used and therefore I can safely delete it?

Even when the field is indexed, the value list does not insert values on new records. Strange! I'm using the "All" option for indexing.

Nope, I forgot it. It now works like a charm. Thanks for all your help. You're working pretty early in the morning aren't you? John

It still doesn't work. Script debugger and DataViewer show that $sp is set correctly in the parent script, however it is blank in the child script so the correct step does not execute. In other words the parameter is not passed to the the other file.

Te attached file shows the scripts I am using.Parent and child file scripts.docx

I want to run a script in the other file, depending on the value of a parameter.

How can I pass a script parameter to a scrip in another file. I want to be able to run a script in asecond file based on the script parameter used in a first file. Or, is there a better way to do this instead of using script parameters?

I’m trying to enter values from a value list based on a calculation field. Specialists::ActiveSpecialists is an unstored text calculation field. The value list ActiveSpecialists reads values from this calculation field. On a new records layout the VL is attached to the Prescriptions::Specialist text field so I can select a name from a drop down list. However, on newly created records, when I select a name, it does not enter into the field. The field remains blank. The source table for the new record layout is Prescriptions. How can I get the VL to work? Update: The value list does not work on new records only. That is, when I create a new record and apply the VL the field remains blank. However, the VL works fine on previously created records.

How can I print field boundaries? I want to print boundaries on some fields for emphasis.

Why setup a default printer? It seems that every time you print within a script the default changes to the one in the print step.

FileMaker 17: To update records in table2, I want to import only the new records in table1 into table2. What’s the correct option to use in the Import script step: Add new records, Update existing records or Update matching records?

I'm looking for a field calculation that will break a number into groups of 4 digits, each group separated by a space. The number can have 5 or more digits (say up to 16). For example: XXXXXXXXXXXXXXXX to XXXX XXXX XXXX XXXX

Who wooda thunk! FM is not fully compatible with Windows Home 64 bit! I'll just have to live with it. It's hugh job to upgrade Window. All my program would have to be reloaded and most of my Windows and Program customizations would be lost. I've done this enough times to know not to do it unless absolutely necessary. Thanks for your help. Does FM have a patch?

I'm using Windows 10 Home.

I like to see the page margins when working in layout mode. However, View page margins is always grayed out. This happens in all my FM 17 solutions, all layouts. How can I view page margins?

I'm using a global script variable to display numbers on my layout. However, I would like it to display a zero when the result is zero. At the present time, it displays as a blank. Is there a way to do this?

Excel and Filemaker calculates the difference between two dates differently. I always thought that when you subtract two date from one another, the result was the number of full days between the dates. For example: Calculate the difference between 1/15/19 – 1/9/19. There are 5 full days between these dates (10th, 11th, 12th, 13th, and 14th). However, FM and Excel calculations do not result in 5, and they don’t even agree with each other! In Excel, Difference = 7 In FM, Difference = 6 It seems that when you subtract two dates in Excel the result includes the starting and ending dates and therefore it is not the number full days between the dates. In FM the result seems to include either the starting or ending date (not both), and therefore it also is not the number of full days between the dates. What gives?

Attached is a picture of the layout. Print margins are fixed: 12 pt (tob, btm; left and right). Print preview shows 2 pages. There are no other objects on the layout. Print Setup is set to landscape.