Your navigation buttons move you between layouts, not tables. Your layouts might be based on the same table or different tables.
One method is to give your field where the user inputs this data global storage. To give the field global storage, you open manage | Database | fields, find the field and double click it, the select the "storage" tab and select the check box for global storage. A field with global storage is accessible from all layouts and all records so this then becomes available on all your layouts and the field can be included in your export to excel. Please note that this then stores a single value over all the records in the table so if you need to keep track of this for multiple users, this may solve one issue and create another.
You can also move data from one table to another by copying the value to a variable:
Set Variable [$Value ; Value: YourTable::YourField]
Go to Layout [Specify a layout based on the second table]
Set Field [YourTable2::SomeField ; $Value]
Oh yes, and if you define a relationship linking the two tables, it's possible just to include the original field on your layout or as part of your data export just as though the field were defined in the second table.
Thanks very much!
I think the global storage thing is what im after; the value will remain constant throughout the whole survey, so once its set in the begining, i just want it to be repeated in the excel spreadsheet at the end. I'll give that a go, thanks very much!
Be careful if you are hosting your database over a network. Changes to the value of a global field will not be retained from one session to another when used in that context.
thanks for the heads up! i dont think that should be a problem though; the survey is to be used on iPads at customer sites; the collected data is then exported into excel, emailed back to base and thats it; that particular database can then be saved and filed away and a new one used for the next customer.
Thanks for your help! it really is invaluable!