Thank you for replying. You're correct that I need to provide a bit more information. Hopefully the screen shot that I took using the Sniping Tool will help. It is attached as "SmartPractice.jpg"
The program that I am using is a Thomson Reuter's product called PPC's SMART Practice Aids. It is a TR proprietary SQL program that cannot be modified. It is used to perform financial audits. The program works in conjunction with other TR programs and is intended to "walk through" the audit process and simplfy the completion of other templated Word and Excel forms. There is no way to link into these fields and the only way to get data into them (other than cut and paste) is simply to type in the requested information.
So if you look at the screen shot, you will see in the center of the screen below item "1. General Information", a box labeled CIRA'S address:
That is where I would want to enter in the complete mailing address.
I am not showing every possible type of form, but the number of them is significant and it is not uncommon to have a box where you will want more than just a single piece of data from a record, such as a zipcode.
I am very familiar with Excel, but I thought that Word might be the better way to go with this form.
As I need to go through this process for multiple clients, I thought that it would be easier if all of the information was in one database.
The SMART program will actually fill in the Word templates (which are also proprietary by TR). I am simply trying to gather all of my various clients responses into one database so that I can fill out these forms in one sitting as it takes time to open and close these applications.
I hope that I have done this justice in explaining it. Thanks once again.
BTW, just in case you want to know what "CIRA" means, it stands for Common Interest Realty Associations. These include condominiums, homeowners associations, master associations, timeshares, etc. Fun stuff
