Linking multiple tables to forms

  • Thread starter Thread starter Fran
  • Start date Start date
F

Fran

Thanks for you previous help.

I have created a form and manually linked my first table
to this form using the recordsource of the form. I now
have a second table which I need to link to this form.Do
I have to use a sub form to achieve this or will one form
do? If I have to create a sub form what will be the best
way to do this under these circumstances?

Thanks
Fran
 
Fran

You have not provided any information about how the data from table1 and
table2 are related. Tables hold data (related or otherwise). Forms display
data.

What are you trying to accomplish by putting data from table2 on the same
form as table1 data? Knowing this will help me better assess if a subform
is appropriate...
 
The first table will hold personal info eg CustID, Name,
Address, etc. The second table has custID and two text
fields. The form is a repairs form that captures personal
info (table 1) and Equipment In and Fault (the two text
fields of table 2). I can have one customer with many
repairs. It is this second table that I need to bring
onto the form. The CustID is the common field on both
forms.

Thanks
Fran
 
Thanks for the additional info, Fran.

You already have a main form (for customer info). Create a second form,
using the second table as a source.

Now open the first form in design mode and select subform from the tool bar.
You will be prompted to indicate the "connecting" fields -- from what you
indicated, CustID is in both tables, and is the way the two forms (main/sub)
are related.
 
Fran

Tom's comment is a good reminder. A Form can be based on a table or on a
query. A query can be based on one OR MORE tables.
 
How many tables can you combine?

Thanks,
Linda
Fran

Tom's comment is a good reminder. A Form can be based on a table or on a
query. A query can be based on one OR MORE tables.
 
How many tables can you combine?

Thanks,
Linda

I've had four tables in one query with no problem. I'm not sure of the
upper limit.

Tom L
 
I'll see Tom's 4 tables and raise it ...

I've joined well over 10 tables in a query... <g>

Check Access HELP under "specifications" for theoretical limits.
 
Jeff Boyce said:
I'll see Tom's 4 tables and raise it ...

I've joined well over 10 tables in a query... <g>
Click to expand...

Was it still updateable though? If it's to be used in a form I would suspect
that editing is a requirement.
 
I'll see Tom's 4 tables and raise it ...
I fold...my query was updateable, though! ;-)

Tom Lake
 
Back
Top