Jamespatricksmith

Hello, I don't think my description of my problem was very good but I am progressing with it. I now think the simplest thing to do is import the data each week and use the add records function. This will give me a record for each person and what hours they have done on which job. I have related the hours table to the jobs table by job number and have a portal on the jobs layout to show all the hours each person has done on that job which is working. The problem I have is that it is listing the persons name multiple times in the portal. Ideally I need the persons name once and their total hours next to it. I have been playing around with sub summaries which I can get to work but not in the portal. Is this possible? Is there another approach I could try? Any help would be greatly appreciated. Thanks James

Hello, Any help with this would be greatly appreciated as I am confusing myself! Basically we have a spreadsheet that keeps peoples hours on certain job numbers. I have 2 tables in filemaker one for jobs and one for hours. I want to import the hours from my spreadsheet into the hours table and have a portal on the Jobs table so that you can view who has done what hours on any particular job. I have created a relationship between job number on hours and job number on jobs. This is all working well. We update the hours on the spreadsheet weekly and when I import the records I choose "update existing records in the found set" which gives me a running total, so far so good. The issue I have is that we have a new spreadsheet for each month but jobs obviously can run over several months. So if a person has a hundred hours showing in the portal as it goes to the next month he might have five hours and when I import it then shows just the five hours. I think the best way would be to, every week that we import the records, adds them as a new line so that effectively you will have 1/10/16 John 15 hrs, 7/10/16 John 7 hrs etc. Then I would need to summarise these hours. Does anyone know of a good way to do this or even if there is a different approach? Hopefully this makes sense. Thanks James

Perfect, thanks for your help. James

Hello, I wonder if anyone can help me. I have 5 databases which will be opened with a startup script and in the layout of each database will be a menu to switch between databases. My question is how can I do this smoothly? Basically I want to emulate what happens when you press control tab which switches very cleanly between windows. I have tried using the script "select window" but the windows get minimised and maximised making the screen flash and is quite distracting. I have also tried the "open file" script step but again this has a delay and becomes quite ugly. The ideal is to emulate the control/tab functionality but I have no idea how. Thanks James