I have a project in development that uses Word documents as an input mechanism to a larger system. My company's client has 4 different Word documents they use that contain form fields. When the document is submitted to our system, it will strip the data from the form fields and store it in a SQL Server database. I realize this isn't the most efficient solution but it solves our client's business problem and allows them to fill out the Word document while offline.
Here is my dilemma: There is a section within 2 of the 4 Word documents that contains a table with Patient Information (about 6 form fields per row). The assumption was that we would just give them some maximum number of rows to cover their needs...however, it seems that their largest report could have 70 rows!!! Is there a way to replicate form fields within a table in Word without using VBA or is this going to require some VBA code to manage?
If it requires VBA, does anyone have an example of some code that clones a table row (form fields and all)?