PASFKS

Hi All, I have a database with 1 main table and 10 related tables. The main table has around 200 layouts and I have just built a navigation menu which effectively has 10 tabs and on each tab is a different portal to a related table. On each portal are 4 fields. So all up the navigation menu has 10 portals and 40 fields. My problem is that I want to copy this navigation menu onto each of the 200 layouts but when I do so the fields in each portal are blank. It will be a massive job (some 8000 fields) to reconnect the fields to each relationship on each layout. One thought I had was to make the navigation menu a separate pop-up window but this does not really work for my solution. I would be grateful if anyone has any hints on how to resolve the problem, Thanks in Advance

Sorry about that, just trying to keep it simple - obviously made it to simplistic. The calculation I am trying to devise is one which returns the correct Paid-To date for any amount paid irrespective of whether that instalment spans multiple days, months, years etc.

Thanks Comment. I did have a go at this early on and it works well in isolation (ie one month) but I found with multiple months and multiple instalments of many different values it created it's own complications (adjusting for different vslues, month lengths, leap years etc). I might give it another go, regards

Thanks Balder and Emma for your comments. Have been playing around with hours and time stamps but not really had any success. At the end of the day I have to convert the hours to a date and still get the same rounding problem. I will keep working with hours and see where I get to . . .

I am trying to calculate a paid-to date but have struck a problem when a person pays by instalments eg: Month - April Start Date - 1/4/2007 (the first day) End Date - 30/4/2007 Payment Due - $1000 at a day rate of $33.333333 (ie $1000/30days) 1st Instalment paid is $750 which gives the number of days at 22.5 (ie $750/33.333333) So the paid to date becomes 22/4/2007 2nd Instalment paid is $250 which gives the number of days 7.5 and a paid-to date of 29/4/2007 NOT 30/4/2007. The problem is the half day which is rounded down by FileMaker. If I round up the paid-to date becomes 1/5/2007 which is still not 30/4/2007. Any ideas on how to handle this rounding problem would be greatly appreciated.