KYC

Using FM10. Have a Purchase Order file, Line Items for it, and a Work Order File. PO file has portal from line items. Customer wants Purchase items to appear on Work Order. Problem is, his PO numbers and WO numbers are calculations involving unit numbers. I have a portal in WO, linked to PO line items, and if I manually type in the WO number in a relation field tied to line items, it works. I need to convert the calculation for WO to a text or number field, or find a better way.

Just converted a parts inventory set of 9 related files from FM7 to FM11. Imac. Everything went fine, except now my "open all" script doesn't open all the files. All but 3 wont open automatically. As a each file opens, it asks for the same related file, which I select from the file menu. As other files open, with a relationship, they too cannot find those certain files. I've looked at the file names, they are just like the others. I've check the relationships, there the same. Checked passwords, network settings for each. Once I get through manually opening those 3 or 4 files over and over again, everything works as it should. Filemanes are "Service.fp7" "Vendors.fp7" "Parts Inv.fp7". Never seen anything like this. Does anyone have any ideas.

That was it. There were many files with old or unused address's. Thanks for the help

Converted files from Filemaker 7 to 10. No problems but this one: Have about 18 files in a folder that are scripted to open automatically by one open script. Worked OK in 7, but I have two files that wont open automatically in 10. Filemaker says it cant find them, and I end up selecting them from the folder list each time. All files are basically the same. All files appear in the folder, but two wont open when instructed by the open script. Same format, same everything. Checked and rechecked all relationships and scripts in the other files. I must be missing something. Any one have any ideas?

Thanks for the formula, you're a life saver.

Problem: Need a formula to find previous lowest odometer reading for a list of records of randomly entered odometer readings so I can calculate MPG. Example. Previous record readings were 41789,43582, 47135, 46902. New reading is 44234. I need the calculation to find 43582, the previous lowest reading. Each reading is a new record.

I have a file with many purchase order records. Each record can have a different purchase order number. There can be as many as 30 records with the same purchase order number. I want to find and print all the records with the same purchase order number that are on the record the customer is looking at, without them having go to the find mode. It won't always be the Max purchase order number. This script will then print a Purchase order summarizing all those found records. Is there a script step I am not aware of that allows me to set a find criteria without using the manual find routine?

I need a calculation to arrive at the number of vendors used from a list of sold items.Each item has a vendor number.The find shows vendor 101 may appear 23 times, vendor 203 may appear 15 times. I need to summarize the number of vendors used. The answer I am looking for is:Number of Vendors= 2

I would like to keep a listing of all my scripts on my Palm. On a regular computer file I would import all wanted scripts into the scripts area. The Palm is going to require a text field to hold those scripts. I know there are programs that allow you to write your script in a text document and insert it into the script.I need to do the opposite, I need a way to copy scripts into a text field.

Have a file with daily entries of odometer readings for over a hundred delivery trucks. When the client makes a new record in that file, and enters the truck number, would like to have the last odometer reading for that truck number be automatically inserted in the new record. Can

I guess I can't see the forest cause of the trees. Lets review: This is for a non-profit shop where they pay the craftsman each month for what is sold. I have a sales file that includes the craftsman's number and item number. There can be up to 1500 (records) or sales in a months time. There are about 100 craftsman, who can have multiple sales each month. The summary worked because I need to summarize the sales by Craftsman's number, and assign a check number for each summary, and number the checks with a starting number that changes each month, and have it automatically number each check sequentially. I don't want them to have to number individually, and since they can sometimes handwrite a check or mess up a check, each time they run checks, it will be a different starting number. Now I am at the check register problem. I guess I can't comprehend the conventional solution with the above problems. I'd appreciate any suggestions.

I use summaries to print checks. Thanks to Bob Weaver, I can now number the checks sequentially. My problem is I need to put a checkmark beside each check number when I reconcile, and of course you can't enter a checkmark when in Preview. I don't want to export to Excel. Anyone have any ideas?

Thanks Bob, that is just the ticket. I sure appreciate your work. I use a very old Macintosh desk accessory called "Image Grabber". I use it all the time to extract just a certain area, or the entire screen. It saves text as a graphic, but still works wonderful. It is not the present day Neotech Image Grabber, which is a card.I don't have any address or company name, I have transferred it from one mac to another throughout the last 5 years. It won't let me paste into this area however. Again thanks for the help. I owe you one.

Bob, This appears to be exactly what I am looking for. However, there is a problem with the numbering of the invoices.. It numbers the invoices (records) correctly for the first set of vendor records only. I have tried different things, but I think it is the Set Field [Current vendor <>Vendor ID]. It doesn't seem to be finding the unique vendors; it gives each vendor more than one check number. Thanks for the thoughts about the integrity of the check numbers. I had thought about using lookups in the check file. All menu bar commands will be disabled anyway.

Thanks for your idea. I have been trying out different scenario's to make this work. Your idea works fine if I was only generating one check at a time. I had not mentioned that I am taking about 400 invoices (records) and generating checks to about 100 vendors (sorted by vendor ID #) at one time. I had planned on importing these records into a checking file, sorting by vendor ID #, and using the summaries to generate the checks. I need to enter the starting check number, and have it generate the sequential check numbers for each vendor. Is there a way when I import, to assign different check numbers to the different vendor ID #'s? I appreciate your help. I have been using Filemaker for many years, but have never come up against this problem. Thanks Again

I use summaries to generate checks. I have the summaries already done, but I need to assign check numbers to each summary by entering the starting check number and have Filemaker number each summary. Does anyone have any ideas short of exporting and importing the summaries? I would really like to export summary fields to another Filemaker file, which would result in a record created for each summary. According to the books, I can't do that. Thanks for your time.