jrp

Dang, I wish my brain worked like that. Thank you both!

Seems like this should be simple, but I'm stumped. I have the Week of Year (44), and the Year (2003), and I would like to calculate the date of the Sunday of that week (10/26/03). Possible? Many thanks in advance.

(edited to add some more info...trying to clarify my problem) I have a report that has no body - just multiple subsummaries, in a large line item file. Every record in this file is an line item from a timesheet - related to both a staff member (who exists within a department and within a company) and a project. The Subsummaries are: Company Department Staff Member Project Name All of which have an hour total and a cost total, using summary fields. I want to also include a summary of the count of projects. So a staff person clocks 36 hours, costing $720, and worked on 7 projects total (each project also has a break-down of hours and cost). But if I create a summary field that is the count of Project Name, I get the number of records (which might be 79) - not the number of Projects. Can I get a count on a summary? Many thanks.

You both completely rock. Many thanks!

I'm setting a Letter Body field with auto-entry of a calculated value: some text, then a currency figure from a related field, then more text: ---- FOR SERVICES RENDERED IN ARRANGING " & Upper(type_of_loan) & " LOAN IN THE AMOUNT OF $" & amount_of_mortgage & " ON THE ABOVE REFERENCED PROPERTY WITH " & Upper(Company_Name) &"." ---- I would like the currency to appear formatted, with the "$" and commas in the appropriate places. (ie. $900,000 ) But in a text calculation, only the text (900000) comes out. Does anyone know a handy calculation to parse out the numbers and get the commas in the right place? Many thanks!

Yes - the many-to-many is staff to projects, and the "bit more information" is the task that each staff member is doing on the project - a field that doesn't belong in the project file, or the staff file, neh?

OK - found the info I need, and some good theoretical discussion on the values of multi-keys and join files - good stuff! I think I'm going to go ahead and create a join file for the example I listed, since I need to store a bit more information about every link. But there's another instance of this in my solution where the multi-key relationship will work perfectly. It's certainly a nice tool to have in my belt. Thanks again!

I do understand that about repeating fields - which is why I was uneasy. I'm still unclear about the other options, though. I'm about to go searching through my books and this forum for more discussion of multi-key fields, but if you have time, and could explain it a bit? I would be most appreciative. Thanks.

*Repeating fields as Keys* I

Thank you! (btw, the first problem seems to be happening only in 12 pt fonts - so I fixed that.)

I have two value list questions: First, a formatting problem that I'm beginning to suspect can't be solved: My value lists, in pop-up lists, are displaying without enough space between each line, and the top bit of the text is getting cut off in each line, making it difficult to read. I've tried to play with the paragraph formating of the field, but nothing has any effect on the display of the list. Is this just a bug? (I'm using FM 6.0v3, Mac OS X 10.2.1) Second, I would love to copy the entire index of a field, so that I can use that to create a value list in another file (one that won't, eventually, be related in any way). How can I access that index? Many thanks!

I'm not at all sure where this question belongs, so I'm going to try relationships. I have 2 files: Reps Districts I need to do a monthly import of revenue data from an Excel file containing three fields: RepID, DistrictID, and Revenue. Most line items on this file will contain both a District ID and a Rep ID, but a few line items will only contain one or the other. I need that data to be available to both the Reps file and the Districts file, and I need to be able to summarize revenue for both Reps and Districts, based on Last Year's Total, and Current Year to Date. I created a third file, called Rev_LI (revenue line items) into which I import these files. I created a script to assign each line item, on import, a month and year. I created relationships from the Reps file and the Districts file to the Rev_LI file. But now I'm stuck. I can't figure out how to summarize the data into "Last Year's Total" and "Current Year to Date" on either the Reps file or the Districts file. Can anyone suggest a method? Would be so grateful.... jrp

Just a note on this: I encountered this same issue on a client install today. Filemaker Tech Support recommended a re-install of OS 8.6. This resolved the MPLIBRARY issue.

You can never index a calculated field. I believe that's rule you can't break. (I could be wrong, and would LOVE to know how). But - you can make your field a normal, indexable field, then put your calculation into a script or auto-enter value. This way, the calculation is done *to* the field, which should still give you the data you need, while allowing the field to be indexed.

I want to perform a lookup in a field, then restrict the editability of a field *only if* another field is not empty. If the user selects an ItemCode from a drop-down, the Term field should lookup that term from the related file