link data on forms and tables

[chris]

This is a rather complex problem that has no simple answer.
It would be much easier to offer advice after seeing what
you have done so far.
Would it be possible to send me a zipped copy of your
database with sensitive information (if any) removed?

Send to
chris
at
mercury-projects
dot
co
dot
nz

-----Original Message-----
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...)