6 Replies Latest reply on Oct 31, 2012 9:20 AM by davidanders

    copying a cell from one table to another...

    OllySedden

      Title

      copying a cell from one table to another...

      Post

           Heya,

            

           I'm REALLY new to FileMaker (and software programming stuff in general!) - i've created a survey that has multiple sheets and uses navigation buttons to move between the tables. On one sheet (lets call it sheet A), i ask the user to input a value; for example, how much do they pay for electricity (p/kWh)? 

            

           On another sheet (lets call it sheet B), i record lots of information for multiple rooms in a building (so one record per room in the building with multiple fields of information in each record) - but i want the rate the customer pays for electricity to be exported in the excel sheet at the end... the excel sheet is exporting the data collected in sheet B, but needs that single field from sheet A to come with it aswell....

            

           This is probably quite a simple and silly question, but would love it if someone could spell it out for me! i've tried linking the tables but im failing miserably...

            

           Any help would be much appreciated!