This is a very small app I need developed in .net This app will run off of the attached MS Access database. There are tables: category, inv, item_cat, status, location, and web_items I need the app to be very simple I want the [url removed, login to view] related to table.web_items by itemnumber I want the table.web_items related to table.item_cat by itemnumber or item_id and table.item_cat is related to [url removed, login to view] by cat_no If is necessary to change the database or database structure please do. Also please check the database structure to make sure it is set up correctly The following items are to be displayed all on same form main table = [url removed, login to view] in datasheet/datagrid view I need the fields status and location to be dropdown boxes to choose specific data (like in the table). If this is not possible in datagrid we can separate them from the table. Item number from field Item_Number should be automatically filled into subtable web_items subtable = table.web_items in single item view I need this to be related to the main table inv by item_number. Item ID from field Item_ID should be automatically filled into subtable category or really Item_cat. (like I said if this needs to be changed no problem) subtable = [url removed, login to view] (I need to be able to choose multiple categories of each item) I need this table related to the table web_items. I also need this to be a drop down and be able to choose multiple categories. There should be the ability to add and delete records, When deleting records or closing the app there should be a fail safe if there is unsaved data "There is Unsaved Data. Do you wish to Save?" Yes or No. There should be the ability to name the database I mean the real database is not named [url removed, login to view] so I need the ability to point to a new database. The proper labels for each fields are in the database tables (caption) There needs to be a search field. So user can do a quick search for items. Also the tables need to be editable. Also there needs to be a way to add new categories if necessary to the [url removed, login to view] To start this is all I need. After this project is complete we will add to this base project in future projects. Also please advise on any other ideas you may have I also need this done very quickly thanks
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.