Create a Form from Multiple Tables

[Guest]

I am trying to create a form from data in about 8 tables. When I use the
wizard and only two tables, I get the option to include all data in one
DATASHEET view. However, when using more than two tables, I do not get this
option. When I go to the datasheet view (I want to create an Excel CSV file
of all the data), there is no data displayed, although all the fields I want
are in the headers.

 

[Guest]

Your best bet is to create a query that includes all the tables. The form
will then see it as one data source. The only problem I can see is how you
will join all the tables. Hopefully, there is a field common to all to be
able to join them in a query.

 

[John Vinson]

I am trying to create a form from data in about 8 tables. When I use the
wizard and only two tables, I get the option to include all data in one
DATASHEET view. However, when using more than two tables, I do not get this
option. When I go to the datasheet view (I want to create an Excel CSV file
of all the data), there is no data displayed, although all the fields I want
are in the headers.

If you want to export to Excel, you don't need a Form; you need a
Query. As Klaatu says, it may be a problem creating the proper joins.

How are your eight tables related? Is there a field in each table
which lets you join that table to some other table? Are the tables in
a one-to-many relationship, or are they instead eight tables with the
same structure, just different subsets of the data? More info please!

John W. Vinson[MVP]

 

[Guest]

After looking a bit more, I think you hit the button with the join types. The
tables are all different information from the main file. I've changed the
join types and am now getting better results on the query. Once I get all the
join types right, I think it's going to be OK. Thanks for the info.