G
Guest
Is there a way of creating a form which diplays
information from differnet tables in one form
information from differnet tables in one form
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob
Sure...you can use a query that links the tables together
as the form's record source.
as the form's record source.
R
Rick B
Yes, base the report on a query and include multiple tables in the query. I
would expect that almost every form you build would be built in this way if
you have truly structured your tabels as a standard relational database.
Rick B
Is there a way of creating a form which diplays
information from differnet tables in one form
would expect that almost every form you build would be built in this way if
you have truly structured your tabels as a standard relational database.
Rick B
Is there a way of creating a form which diplays
information from differnet tables in one form
R
Rick B
That should have said ... base the FORM on a query...
Yes, base the report on a query and include multiple tables in the query. I
would expect that almost every form you build would be built in this way if
you have truly structured your tabels as a standard relational database.
Rick B
Is there a way of creating a form which diplays
information from differnet tables in one form
Yes, base the report on a query and include multiple tables in the query. I
would expect that almost every form you build would be built in this way if
you have truly structured your tabels as a standard relational database.
Rick B
Is there a way of creating a form which diplays
information from differnet tables in one form
G
Guest
yes thats correct, however when I do that I change my
record source and then all other fields that I need to use
become Inoperable. I guess I need so sort of way to
include both sets of information is that possible?
P.S.
thank you for the reply.
record source and then all other fields that I need to use
become Inoperable. I guess I need so sort of way to
include both sets of information is that possible?
P.S.
thank you for the reply.
G
Guest
Yes you are correct but I need this for for data entry and
a select query will not let me input new information. Is
there something that I'm missing?
Thank-you for your reply
a select query will not let me input new information. Is
there something that I'm missing?
Thank-you for your reply
B
Byron
This is what sub forms are for.
I will assume that there is a common field in the two tables.
Just create a form (subform) for the information from the
second table and then drag and drop the new form into the
original form.
Take a look at the properties of the sub form and be sure
that the link fields are correct.
That should do it.
HTH
Byron
I will assume that there is a common field in the two tables.
Just create a form (subform) for the information from the
second table and then drag and drop the new form into the
original form.
Take a look at the properties of the sub form and be sure
that the link fields are correct.
That should do it.
HTH
Byron