How can I use linked records to create scalable reports?
I am trying to build a maintainance databases with “assets”, “maint types” and “log”.
For example…
Assets: red truck, white truck
Maint types: engine oil, etc
Log: date + asset (link) + Maint type (multi-link)
I would like to create a report for each asset & maint type combo when the last date of maintenance was.
I am aware that I can use logic formulas on the “log” and use rollup on the asset to find the latest date in a specific category, but that requires unstable and manual formula creation for each maintenance type.
Goal:
Item, Asset (link), Maint Type (link), Latest Service Date (for this combo)
Here is a read only version of the base…
@W_Vann_Hall I thought this might interest you. I looked at several of your examples and posts, but could not find my solutions… perhaps you have already solved it and I missed it.
