Downesy

Hello all, I'm creating a database that keeps count of the amount of profit/loss a client has made by following our stock market advice since the date he/she joined. I have 2 databases, "Subscribers" and "Selection_Results". The "Subscriber" db contains the clients name, address, join date etc. The "Selection_Results" db contains all info about the stock selection, date the selection was given, profit made, etc. I have made a relationship between the 2 db's with called "profit_to_date", with the match file "subscriber::date_joined" with "Selection_Result::Selection_Date". My problem is... Instead of just matching the "date_joined" with the "Selection_Date" field, I need to match the "date_joined" date to the present day date. Can anybody help me out with this one? Thanks

Hello all, I'm not very experienced with Filemaker so excuse me if this is a stupid question. I'm creating a database that keeps count the amount of profit a client has made by following our stock market advice since the date they joined. I have a database that contains the details of the stock advised, and it includes the date advised and the profit or loss made. I have a 2nd database that contains the client information, name, address etc. I need to have an alert when a client makes a certain amount of profit. I'm OK with everything except, I don't know how to calculate the runing total of profit/loss SINCE, the client joined. Help would very appreciated Thanks