I'm still having to convert my thinking from Excel to FM so probably missing the point but:
1. I need some intermediate ID and calculation fields and be able to view them in Table view. However, I don't want them appearing in the 'front end'. Because a field disapears from Table view if you delete it in Layout, in order to see the field, will I have to create a 'backend layout' together with associated Table, in order to view these fields.
2. As I develop the solution, I'm findings I would like to move a field from one table to another (ie. not copy/duplicate/port, just move it). How do you do this?
Lastly, is there any guide in how to develop equivalent functionality in FM to that in Excel? I don't mean direct conversion, just insight into how you achieve similar ends.