Joining Tables

[Guest]

I currently have one table in a database that holds all information for each
project. It is currently set up so the the user enters the job name and is
given a job number via autonumber.

It is quite large and I would like to break the 1 table into several - for
example 1 table for job name, address; 1 table for bid results; 1 table for
owner name and address. What is the easiest way to break up this table?
What field would I use to join them for queries since the job number field is
autonumber?

 

[[MVP] S.Clark]

There's no magic wand for normalizing, non-normalized tables. Just grunt
work using the family of action queries. During the process, you would need
to copy the autonumber value to the child tables, then use it for linking.

 

[Guest]

Please excuse my ignorance here but....I am assuming I should copy the
portions from the original table to the new table along with the autonumber
field. What happens to new records when they are added. Are the child table
updated?

 

[[MVP] S.Clark]

If you use a form with a subform, the Link Master Field and Link Child Field
properties will ensure that the child records are updated with the proper
ParentID.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting