tables in forms

T

TK

does anyone know how to add additional tables to a form? I created a form
using the wizard and I now need to add more tables to the form. Thanks for
any help

Tom
 
S

Steve Schapel

Tom,

I think the basic concept here would be to make a query that includes
all the tables that hold data that you want on the form. Set up the
query so that it returns the data you want, and then enter the name of
this query as the Record Source property of the form.

On the other hand, it could be that you really need a form/subform
construct.

Please post back with more details, including examples, if you need more
specific help with this.
 
J

John Vinson

does anyone know how to add additional tables to a form? I created a form
using the wizard and I now need to add more tables to the form. Thanks for
any help

Tom
Click to expand...

Please explain how these tables are related. You can base a Form on a
Query joining tables, or (more likely) you can add Subforms; typically
if you have two tables in a one-to-many relationship you would use a
Form for the "one" side table with a Subform for the "many".

If your tables all contain the same type of data and have the same
fields, you need to step back and redesign your table structure.
You're better off having one big table with a field to distinguish the
groups.

John W. Vinson[MVP]
 
T

TK

I've got 10 tables and I have them all directly related to each other. It
certainly sounds like i need to re-organize my table layout. All of the
tables have the same amount of records and fields, any suggestions how i need
to reorganize?
 
S

Steve Schapel

TK,

Probably all the data can go into one table, with an additional field in
the table to identify whatever it is that distinguishes the data in each
of your existing tables one from another.

If you are able to give some specific details it will make it easier for
us to assist.
 
Top