gersam

Thanks Conultant...that was helpful not only for the current issue, but also for another similar issue I was facing. You're a genius...

Hi Conultant, I'm trying to make an attendance timesheet as part of a largr Payroll module. I'm using repeating fields because I dont want to create 31 fields for January for every month. I also dont want to have to repeat the exercise in 2011 and thereafter. Can you help?

Hi All, Small Problem...Defined a field called "CurrentMonth" and a field called "Day" which is a repeating field of 31 days depending on the current month. If CurrentMonth = January 2010 then I want to have Filemaker auto-enter the numbers 1-2-3...31, etc. into the repeating field of "Day". Any ideas?

Thanks John...You're right... The only problem is that you would have to set the path (browse for path because it cannot be set manually for a container) from each network computer and the resulting container file takes ages to open (even though the file size is only 54k). Why does it take so long to open?

I'm running Server 8 with access for 20 different users. We created an HR database file that contains a summary of job descriptions. For each record (80 toltal records) we use a container field that contains a PDF file of the full job description. The problem is that in the server the link is correct and opens easily. But when called from a network computer, the link does not open and gives the message "Windows Cannot Find the File..." Any suggestions...why does it work in the server but not on the network computers. This is wierd because when you assign an object to the container, its as simple as browse for the file. Appreciate any help I can get...

I have three files, one main file and two sub files (company A, company . The two sub files contain company name and position lists for each. In the main file I want to do the following: if I choose company A from a pop-up menu then I want to see the position list of that company, otherwise if I choose company B, I want to see the postion list of that company. How can I do this...any ideas? If this seems unclear, then go to "www.cars.com". What I want to do is similar. If you choose Chevrolet in the "Make" pop-up menu, then you get only the Chevrolet models in the "Model" Pop-up menu. If you choose "BMW", you only get BMW models in the "Model" pop-up list.

I have three files, one main file and two sub files (company A, company . The two sub files contain company name and position lists for each. In the main file I want to do the following: if I choose company A from a pop-up menu then I want to see the position list of that company, otherwise if I choose company B, I want to see the postion list of that company. How can I do this...any ideas? If this seems unclear, then go to "www.cars.com". What I want to do is similar. If you choose Chevrolet in the "Make" pop-up menu, then you get only the Chevrolet models in the "Model" Pop-up menu. If you choose "BMW", you only get BMW models in the "Model" pop-up list.

Hello All... I want to summarize calculation results from 10 different filemaker 8 files into one Summary File. Each of the 10 files has 500 calculation fields. I have successfully made the Summary File through relationships and calculations to add the major fileds and summarize them on to one sheet in my summary file. But I can't store the fields in my summary file because they reference calculations in other files. This makes the Summary File very heavy and slow to give results (up to 2 minutes waiting). My computer is fast and has plenty of RAM so its not a problem with the computer. It must be in the way I calculate the results. Any ideas??? Gersam

Thanks, Jeff. But unfortunately it still didn't work. I DON'T think the problem is in the formula. I think the problem is with me. But kindly explain to me step by step because I am not an expert. Your solution doesn't contain the "IMPORT" command in the script, Why? Here's the issue...I have created a "Training Events" Filimaker program in FP7. Two linked files. One file is called "TRAINEES" with a layout called "Training History", and the other file is called "EVENTS". The "EVENTS" file contains the name of a training event in a single field "Event Name" and multiple trainees in a repeating field for those who attend each event. I now want to automatically update the trainees history of attending the events. The History layout in the "TRAINEES" file contains a repeating field that holds multiple training events. I need to import the "Event Name" to each trainee's history. So I am importing a single field into a repeating field when the registered trainees in the "EVENTS" file matches the trainee's name in the "TRAINEES" file. I apologize if this sounds confusing. Can you help?

I have the same problem as charles and the loop suggested by Jeff didn't work. I have Non-Repeating field data in one file (FP7) that I need to import into a repeating field in another FP7 file. I dread doing it manually...any other suggestions?