Charles Hui writes:
After reading your article “ACCESS Archon Column #44 – Merging to Word from Linked Access”, I have expanded my WORD template to include a table and have successfully created letters using custom doc property and table together. In our letters, the fixed Borrower Name and Address are printed at the top of each letter, and the variable account information of each Borrower is printed in the letter body. Each letter has different number of rows of record in the table.
Do you also know a way to have a table within a table for nested variable info? Using the “Invoice” example in your article #44; for example; I also want to print out factory info (factory name, address, and factory rating) of each product at the invoice detail line immediately after each product, and each product has variable number of factory(s) (some product are manufactured by 2 factories, so there will be 2 line of info, and some product may be made by 5 factories).
Assuming that the tables are linked one-to-many, you could set up another recordset for each level of detail, and add new rows to the table (probably in a special column for each level of detail). In your case, you could set up a recordset for factories that are linked to the product, and list them in a Factories column for each product.
