T
Ted
Hi Danielle,
You had a lot of questions in your message, and I'm not
sure that I followed it fully, but you can put fields
from more than one table on any form. There are two main
ways to do this. For the items that have a 1:1
relationship, you just base the form on a query that
links the tables and includes all of the fields that you
want. For fields that have a 1:many relationship, you
add a subform to the main form and define which field
between the main form and the subform will link the two.
As far as converting a list format to separate records,
this would require writing code (at least I can't think
of any other way). You're really better off most of the
time entering items as separate records in the first
place (in a subform).
-Ted
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.
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...)
You had a lot of questions in your message, and I'm not
sure that I followed it fully, but you can put fields
from more than one table on any form. There are two main
ways to do this. For the items that have a 1:1
relationship, you just base the form on a query that
links the tables and includes all of the fields that you
want. For fields that have a 1:many relationship, you
add a subform to the main form and define which field
between the main form and the subform will link the two.
As far as converting a list format to separate records,
this would require writing code (at least I can't think
of any other way). You're really better off most of the
time entering items as separate records in the first
place (in a subform).
-Ted
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.
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...)