Fields viewed in Table
I created a 'date field' that was equal to a Timestamp field in order to calculate time elapsed (didn't appear to be able to do it from the Timestamp field). However, I didn't want the 'date field' appearing on the form, so deleted it. It still exists and the calc of time elapsed works but the date field no longer appears in the table.
Where could I view it as a table? This is important because I want all fields to be exported to Excel, so would I be advised to have all fields in a single table and just use this table as a 'pot' of fields from which to related to other layouts/tables?