Best Road To Take
Posted on 2012-04-11
I am wondering if I am taking the correct approach to a program. I produce documents for clients based upon the state requirements and by project name (construction related). So I have a folder per state with several Word documents. These documents contain links to a table that the user fills out specifying names, addresses, work description, etc. This works fine but I want to write a program that is easier for my clients to use.
I am thinking that I need to build datatables in VB (one for each contact type ie "Owner", "Contractor", "Architect", etc.) I wish for my clients to be able to "add" information that will then become part of a drop down menu as many have repeat customers, contractors, etc.
I then want to be able to copy these fields into the Word document (either by bookmark or others have suggested mail merge).
Another expert told me to build a text file in VB but I don't think that is necessary. I want to make sure I start this with a good foundation so any advise would be helpful. You guys have been awesome thus far in helping me and I really appreciate it.