Creating database wherein there are multiple tables with same fields under different categories

by Laxman Rathod   Last Updated October 10, 2019 02:06 AM - source

Good morning Sir/Maam, we have vehicle/equipment repair workshops located at different places, these workshops send a monthly report in a standard format in MS Word file (att a sample copy)to the headquarter(HQ). The HQ then compiles and merge data inside these MS Word file into a single MS Word File (same standard format) and further sends to next HQ in the chain and this process continues. Since this is a manual process and time consuming and also prone to human error while compiling data, it's better to automate this process which will also help in doing analysis.

I have started developing the web-based application using .Net, MSAccess database, currently doing the role-based login module. But I am facing difficulty in following things 1. Creating the database due to the complexity of the standard format as it has multiple tables with same fields(Ser No, Type of Eqpt, BBF etc) for different category of vehicle/Eqpt and further the type of Eqpt contains a unique value for that category of veh/eqpt and further do totalling.

  1. Once the database is created how can I create a form such that all the values for these different tables shown in MS Word file gets submitted in single form SAmonly rather than creating multiple forms for different tables which will be not user friendly.

  2. Once the workshops submits the form for that particular month, then the HQ should be able to merge the data and generate report

Sample copy of word file attached .

Sample copy of word file

Related Questions

How to eliminate complex sub queries?

Updated July 07, 2019 23:06 PM

Export ms access report to excel vba

Updated September 22, 2017 11:06 AM