D
Danielle
I have a two part question. Please bear with me....
I am trying to create a database for work that will work with mail merge. I have 4 tables set up: Company Information, Product, Rates, and Renewal Information. I have also set up forms with the same name. I have fields in each table that I would like to carry over information to the other forms. For example, I want the Company Name from the Company Information form to autopopulate in all of the other forms. I also have another field I need to do the same thing with, it is in each form and I would like to link it somehow so it will autopopulate.
Do I have to link the tables and forms to each other somehow? How do I do this?
Is there a way to split the info from one form into multiple forms? For example, in my Company Information form, I have a field for Line of Business which the data is put in as " example" or "example, example, example" for multiple lines. Is there a way to link this field from this form to the Product form but split it so that a) the Company Name autopopulates to a new record and the Line of Business (for the multiple lines) each gets it's own record? (I hope this makes sense...)
I am trying to create a database for work that will work with mail merge. I have 4 tables set up: Company Information, Product, Rates, and Renewal Information. I have also set up forms with the same name. I have fields in each table that I would like to carry over information to the other forms. For example, I want the Company Name from the Company Information form to autopopulate in all of the other forms. I also have another field I need to do the same thing with, it is in each form and I would like to link it somehow so it will autopopulate.
Do I have to link the tables and forms to each other somehow? How do I do this?
Is there a way to split the info from one form into multiple forms? For example, in my Company Information form, I have a field for Line of Business which the data is put in as " example" or "example, example, example" for multiple lines. Is there a way to link this field from this form to the Product form but split it so that a) the Company Name autopopulates to a new record and the Line of Business (for the multiple lines) each gets it's own record? (I hope this makes sense...)