Access 2010 Web database form question

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.

If you are using access (any flavor) behind a website you have serious problems.  Access is by definition insecure.  If you want to be taken over by every script kiddie out there go right ahead.

I would recommend just about anything, including SQL Express, over Access.

3 days ago, qwert231 wrote

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.

Have you tried Lightswitch. I have only read about it. I think Microsoft has targeted Lightswitch as the new Access.

http://www.microsoft.com/visualstudio/en-us/lightswitch

-Steve

@lensman: While normally I would not pick Access, I didn't plan on picking access in this case. I was in sharepoint, selected 'Create new Site', chose a template, and when it was set up and I went to edit it, it opened in Access.

This seems to be a gray area. Whenever I research 'Sharepoint Web Database' I get emptiness.

@qwert231:I think Sharepoint come with SQLCE by default, and I recommand you to use it over MS Access for web development.

I don't think you folks are hearing what I'm saying. I went with a standard Sharepoint 2010 template that Sharepoint provides, and its called a Web Database, and configured through Access. Sharepoint chose the Access stuff. I didn't.

So, I don't know that I'm going to get many answers here.

2 hours ago, qwert231 wrote

So, I don't know that I'm going to get many answers here.

I would ask a Sharepoint question here:
http://social.msdn.microsoft.com/Forums/en-US/category/sharepoint2010,sharepoint/

The templete is called that because it uses a new type of Access files that's called "web database". (If you have Access 2010, you'll find that when you create new database, you'll be prompt to create a "standard database" or "web database". More on that here and  here.)

So if you goal is just to create a whatever SharePoint website, just export the schema there and recreate the same structure on whatever database engine you like and it should work the same.