marcusa

Hi Vaughan, Many thanks for the tip. Out of interest, what method did you use to relate the two tables in order to display the 'account breakdown'...? Brgds, Marcus

Good Evening! Would appreciate anyones views on the best way to maintain a customer cash account within filemaker. The idea being that a customer can deposit a specified amount and then when each invoice is generated, it will deduct the invoice amount from the account balance. There would obviously need to be the option to 'top-up' the account when needed and also to generate a report which shows the breakdown of account usage and when the account was topped-up etc Currently have the basic database configured in a similar manner to the default 'invoice' template which comes with filemaker - Customer, Products, Line Items and Invoice tables... Many thanks in advance! Marcus

Many thanks for the link.. I have actually just seemed to have solved the problem by changing the order in which the case function was written: Formatting it in the mm/dd/yyyy order rather than dd/mm/yyyy order fixed the issue. So basically it was changed from: Case ( Membership Type = "Annual" ; Date(Day(Membership Start) ; Month(Membership Start) ; Year(Membership Start) +1); Membership Type = "Monthly" ; Date(Day(Membership Start) ; Month(Membership Start) +1 ; Year(Membership Start)); Membership Type = "Daily" ; Date(Day(Membership Start) +1 ; Month(Membership Start) ; Year(Membership Start)); ) to... Case ( Membership Type = "Annual" ; Date(Month(Membership Start) ; Day(Membership Start) ; Year(Membership Start) +1); Membership Type = "Monthly" ; Date(Month(Membership Start) +1 ; Day(Membership Start) ; Year(Membership Start)); Membership Type = "Daily" ; Date(Month(Membership Start) ; Day(Membership Start) +1 ; Year(Membership Start)); ) Problem solved for now!

Hello, Would appreciate anyone's thoughts on the following issue please... I am creating a simple field whereby a user inputs a date into the 'Membership Start' field and then selects either Annual / Monthly / Daily from the 'Membership Type' field. There is then a case function which adds a year, month or day to the 'membership start' date and puts the result into the 'Membership Expiry' field. The calculation is as follows: Case ( Membership Type = "Annual" ; Date(Day(Membership Start) ; Month(Membership Start) ; Year(Membership Start) +1); Membership Type = "Monthly" ; Date(Day(Membership Start) ; Month(Membership Start) +1 ; Year(Membership Start)); Membership Type = "Daily" ; Date(Day(Membership Start) +1 ; Month(Membership Start) ; Year(Membership Start)); ) The maths seems to work fine but the problem is that whilst the 'Membership Start' is filed out in dd/mm/yyyy format, the returned values in 'Membership Expiry' appear as mm/dd/yyyy. Selecting a preferred display format from the layout view does not appear to have any affect on the calculated field. The question is how to force a preferred date display in the calculated field? I have attached a screen shot showing the results... Your help in advanced is greatly appreciated. Many thanks, Marcus