I'm using the sharepoint assets inventory template which creates a Web Database. Off of the assets table, I want to create a sub/child table. The table is created. When working with the details of an asset, I want the user to click a button or link and see a new form that lists required maintenance for the asset. Thats easy. I can use a datasheet, or continous form filtered by that Asset. However, when you then create a new entry in the maintenance table (in that form), it does not default to that particular asset. The user will have to choose from a list of perhaps hundreds of assets to select what they want this new entry associated with.
While this design may be useful for some, I don't see why it's so difficult to default new records to have this link.
So, we have an Assets table, with AssetID, and various information. Then a maintenance table with a maintenanceID, an AssetID (which should be automatically linked when in a form and I click new), and various maintenance details.
Perhaps I have not googled or asked the correct question. Where can I go from here? Should I just consider Microsoft's templates a lost cause, and scrap Sharepoint, and write my own ASP.Net app from scratch? I would be able to do just what I want that way.