Tables & field types — Good to know

• Fields follow creation order and are reordered with the ↑ ↓ arrows; deleting then re-adding a field moves it to the end. • Deleting the first field hands the name to whichever field is next — RowFold refuses if that one is a link, a file or a calculation, since nothing could name the records afterwards. • Deleting a field hides its stored values but does not erase them; a new field with the identical key shows the old data again. • A Lookup whose route crosses a to-many relation reaches many records and lists every value it finds — when you wanted one number, that's a Rollup (the builder offers the switch when it spots this).