Magnus

Hi, You're the best -) I just put in a calculation field in parent file A, with sum(relation_to_child::time) and it works like a charm :-) I can see that you are using FMP8 advanced. I've been thinking of upgrading my business system to FMP8 and FMP8 server, but haven't had the guts since I read about a lot of performance problems when FMP7 was released. Any comments on that? I have FMP7 and 8 inhouse but haven't started to use it yet. Any 'as-long-as-you-think-about-this' when upgrading? Cheers, Magnus

Hi, I have two files, A and B. In A I have a portal to B with a relation for a group of records (one group is 7 records, monday to sunday). In B I have a time count for each member of the group (day of the week). In addition to this I have a summary field looking like this... sum(self_relation::time) that sums up the times for the members in the group. But when I'm in file A with all the groupmembers listed in my portal, and I subtract or add time in one of the rows, the summary field does not update. If I change to show another group and then change back again, it recalculates. But not when I change any of the values that the summary field is based on. Any ideas someone?? Cheers, Magnus (I'm using FMP 5.5 on XP)

Hi, In my last app (a calender/booking system) I tried to separate the structure from the data, but failed. Everything is OK as a single user, but as soon as I hook up another user I get a portal lock. The UI main layout is a calender style layout with the rows representing times from 9 AM to 8 PM and the columns representing different rooms. All eight columns are portals. The default position when you start up is the 'today view' so all users will work with the same data (most of the time anyways). Is there anyone that has an idea how I can solve this problem? Cheers, Magnus