Adding a table to a form

I am using Access 2003 on Windows XP.

I created a form from one table. Now that I look at it, I've decided that
some of the informaiton really should be in its own table. Granted, I should
have thought this out better before starting, but now I'm wondering how I can
bring use/add an additional table to build the form.

Any help/suggestions much appreicated. Thanks in advance.

copy your DB - so you are working with an expendible/experimental copy....

sub divide the table into 2 tables - as you feel it would be better
designed...

then create a query that brings together all the data from the two tables
that the form will need

finally go to your form - and in the Properties of it - change the Control
Source from its original table to that of the Query....it is a pull down so
it is an easy change to make.

if you don't change the field names of the two tables - then the table's
field names and the forms textbox names should remain in alignment....and it
should work....However if you change/add table field names then for these
guys you will need to delete the old textbox off the form and from the field
list re-add the new textbox names...

hope this helps...
--
NTC


"Diddakoi" wrote:

I am using Access 2003 on Windows XP.

I created a form from one table. Now that I look at it, I've decided that
some of the informaiton really should be in its own table. Granted, I should
have thought this out better before starting, but now I'm wondering how I can
bring use/add an additional table to build the form.

Any help/suggestions much appreicated. Thanks in advance.