Hello Anakin,
I had a quick look at your project and made a few changes.
Of course, it's based on my understanding of what you're trying to do so some of what I've suggested may be invalid. But at least it may give you some ideas.
In your data structure, you had relationships going in both directions between tables (many:many relationship) but I don't see that being needed with your data. Also, you had a couple of currency / value fields defined as 'integer' (so these would only have displayed whole numbers rather than the precision (normally 2 decimal places) you need).
With some of your forms that hold 'lookup' data (which in your project is pretty much everything except the 'service' and the 'article's tables), it's probably easier to set those up as 'editable grids'. Even the 'asset' table itself is being used just as a 'lookup' for the Maintenance Department, as I understand it. I've grouped all of these together on just one form (which should make your project slightly quicker to load).
Other than that, I've just used the standard MVD approach of listing all 'service' records in a tablegrid and maintaining individual 'service' records on a discrete form. And likewise for the 'articles' table.
Unfortunately, your report is messed up a bit now but than can be corrected once everything else is set up as you want it.
Lastly, there is a small script to initially 'click' the search button (now hidden) on Form1 but that's really just a cosmetic thing.
Again, apologies if some of my assumptions for what you're after are wrong but at least the approach might show you a way to proceed.
Hope this helps,
Derek.
Post's attachments maintenance.zip 347.57 kb, 394 downloads since 2019-01-16