1 Reply Latest reply on Jun 18, 2014 7:13 AM by philmodjunk

    horizontal data

    amyaye

      Title

      horizontal data

      Post

           how can i make my data appear like table two currently it looks like table 1. Iisit possible these fields can automatically create new multiple fields everytime a client visits or is this not possible. 

            

           table 1

            

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
                          Name                     Item Ordered                     Date of Visit                      delivery                     Price                     Delviery Date
                          larry barry                     tv                     01/01/2014                     home                     599                     16/01/2014
                          larry barry                     radio                     07/08/2013                     store                     99                     14/08/2013
                          larry barry                     kettle                     01/05/2010                     store                     50                     05/05/2010

            

            

           table2

            

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                                                visit1                     visit 2                      visit 3
                          Name                     Item Ordered                     Date of Visit                      delivery                     Price                     Delviery Date                     Item Ordered                     Date of Visit                      delivery                     Price                     Delviery Date                     Item Ordered                     Date of Visit                      delivery                     Price                     Delviery Date
                          larry barry                     tv                     01/01/2014                     home                     599                     16/01/2014                     radio                     07/08/2013                     store                     99                     14/08/2013                     kettle                     01/05/2010                     store                     50                     05/05/2010

        • 1. Re: horizontal data
          philmodjunk

               It's possible, using a related table and multiple portals, but not the simplest thing in the world to set up in FileMaker. Instead of "how do I get it to add more fields automatically", think Add more related records (one related record for each visit.)

               And unless your customers never order more than one item, I don't quite see how your horizontal arrangement of data would work anyway.