Plenty of business records are really a header plus a list: an invoice and its lines, an order and its items, an expense report and its expenses. Until now you faked that with a second table, manual links, and a spreadsheet formula for the total. InfoLobby now does true master-detail — natively, and atomically.
What's new
- Sub-tables (line items) — give a table a set of repeating detail rows. On the parent record they show as an editable grid: type across a row, a new blank line appears as you go, and the parent and all its lines commit in one transaction. The lines belong to that record — no orphan rows, no editing them loose.
- Rollup fields — a stored total on the parent that summarises its lines: sum, count, average, min, or max. An invoice total that always reflects its current lines, with no formula to write.
This is a capability the flexible-database category usually lacks — most tools give you linked records with independent identity, not a single atomic header-plus-lines commit. Use a sub-table when the detail rows belong only to their parent; when the rows are shared records, keep using a lookup and a related tab.
Read more in Sub-tables (line items), or see it on the features page.