AnsweredAssumed Answered

values and dates with graphical structure

Question asked by jonascading on Jan 17, 2013
Latest reply on Jan 17, 2013 by philmodjunk

Title

values and dates with graphical structure

Post

     this is my expenses table

                                                                                                                                                                                                                             
                    id                     expenses                     desciption
                    1                     gas                     route gas
                    2                     toll gate                     route toll

     and this is my other table

                                                                                                                                                                                                                                                                                                                                                                                                                                                         
                    id                     expenseID                     date                     amount
                    1                     1                     12/08/2012                     250
                    2                     1                     12/09/2012                     400
                    3                     2                     12/08/2012                     10
                    4                     1                     12/18/2012                     380

     my goal is to have a graphical layout like this.

     for the gas expenses layout will look like...

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                    sun                     mon                     tue                     wed                     thu                     fri                     sat                     date
                                                                                                                                                                              dec 1
                                                                                                                                                        250                     dec 2-8
                    400                                                                                                                                                         dec 9-15
                                                                380                                                                                                             dec 16-22
                                                                                                                                                                              dec 23-29

     my question is how? I am starting to love Filemaker Pro and it does everything from small to heavy data input without having problems. Also I love how easily you can make it available through the web. 

Outcomes