Steve Martino

Genius on the 'Replace' (well to me. To you it's just another day ) How would it look with the While ( ) function? Just curious. Thanks!

Here's a few videos that may help: https://www.youtube.com/results?search_query=FILEMAKER+DUPE+CHECK

First of all, how are you synchronizing between the 2 devices? How are you identifying which line items have cleared the bank? Seems like you have a field for Reconciled with a check box? Is that not remaining checked thru synchronization? If you are doing it thru a script, one of the last script steps should be to sort. If you are not synchronizing thru a script, you can just sort when opening up that layout, or put a button on the layout to sort.

Hey Caroline! Did you try it from the webviewer? I remember doing something like this on my iPad. I'll have a look tonite.

Are the tables are related? Say starting from the left column, the 2nd column shows records related to the first column, the 3rd column show records related to the second. Or Are they just records from 5 different unrelated tables, shown as a dashboard?

Look at GetSummary function https://fmhelp.filemaker.com/help/18/fmp/en/index.html#page/FMP_Help%2Fgetsummary.html

What do you need as a separator.

Did you try running it with the debugger to see if it fails at a certain script step? Did you try running the script from the menu, instead of a button to see if the button is corrupt?

Seems like the fields aren’t big (tall) enough as the data looks clipped. Are you sure all fields are within the sub summary part? It seems like all the fields aren’t the same height or share the same top location. in other words, if the sub summary part top is 400 pts, and the bottom is 420 points, I’d make sure every field, line would start at least at 401, and end no further than 419. Maybe you could post a file and let others see if they can replicate.

How/why are the 'counts' messed up? Using summary fields and finds with dates are pretty straightforward, and using relationships w/GTRR is another way to go. Can you post a small sample file with some data?

For starters you think your report needs to be based on the trip table.

-Enter Find Mode, remove the existing find request (Restore) -Remove Commit step, never needed while in find mode. But you appear to set a variable based on the current record, then do a find for that record. Very confusing what you’re actually trying to do and where the calculation field fits in.

When you delete records from one table are you also deleting any child/grandchild records? Your profile doesn't mention version, operating system, server etc., nor do you mention stand alone computer, multiple users, etc. I do a weekly import/find/sort delete-usually in the 60K range, takes about 25 seconds.

There’s nothing to convert, unless you were using features that were deprecated since 14. Just open the a backup file in 18 and put it thru it’s paces

I must be reading it wrong. Seems to me the OP is looking for a simple find/lookup/GTRR for a job, based on the job number. OP, can you clarify?