Question

I am trying to design a procurement system. I have one main database containing the major items, eg computers, office chairs, etc. Within each of these items is a sub-database containing all the options and quotations we receive, eg under computers you would have supplier 1 with its price, supplier 2 with its price, and so on. On the main database, I want to roll up data from the sub-database such as average price, minimum, maximum, etc.

When I tried to do this with relations, the main database tend to add a column for each relation. So for example, for computer items there will be a column relating to the sub-database within the computer page, then another column for office chairs. I find this unwieldy.

Is there a better way to do this?

Answer 1

That is the correct way to do it.

Relate all the Notion databases you need, then Rollup all the information needed from those databases and at the end just hide the columns you don't need to have visible all the time.