I'm looking for some suggestions on the best way to populate a form from a database or table in Excel. The intent, after populating the forms, is to send them to their respective named individuals for proofreading and updating of the information. Here's the table:
The tricky part for me is that the table is grouped by family (there are several hundred) and then within the groups, sorted by head of the household, spouse (if any), children (if any) in order of age. So in the table, column A is a general index and column B is the family numbering.
For example, the first five entries (red index 1-5) are all in the Baggins family with Dad listed first, mom listed second, and the three kids following in order. Red index 6 is Mr. Fresh Forest who is single with no kids, and the last four entries (red index 7-10) are the Grimp family.
Note that the information in columns C-F is common to all members of a particular family and the content of the remaining columns (G-O) is specific to individuals.
Here is the form which I'm hoping is self-explanatory. (By the way, I'm sending it as an Excel file and as a PDF so that people can print it and make comments by hand if they want):
The family name is simply the combination of the parents' names or single head of household. The form is set up so that members of a family are identified by the number of their position in the family from column B in the table. Therefore, section "INDIVIDUAL #1" could be blank, contain the spouse's information or the oldest child's information depending on the makeup of the family.
This table sample shows data in all fields however the actual database is full of blank cells and therefore the respective form fields will be blank.
Of course, when the forms are completed and returned, the information will need to be put into the database manually — unless of course someone knows of a very slick way to sort of import the updates.