Combine Tables in a Database

[Terry Watson]

I have a database called data.mdb. In it are 2 tables that have 4 fields
that exist in both. I would like to combine the tables into one so that I
don't have to type in the same information twice.
Or, maybe link them together??

 

[Graham R Seach]

Terry,

In most cases, combining 2 tables actually increases the likelihood that
you'll have to re-enter data. Most probably what you need to do is normalise
your tables so that data about each "entity type" is stored in its own
table.

Post your existing table structure so we can begin the process.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Terry Watson]

Fields for Table (Maps) are as follows: Drawer, Name, TMS Number, Date, Job
Number, Location, Subdivision, Block, Lot, Tract, Area, Surveyor, Revision,
Disk.

Fields for Table (DCA) are as flollows: Disk, Name, Job Number, Description,
Date.

 

[Terry Watson]

Fields for Table (Maps) are as follows: Drawer, Name, TMS Number, Date, Job
Number, Location, Subdivision, Block, Lot, Tract, Area, Surveyor, Revision,
Disk.(33,664 records)

Fields for Table (DCA) are as flollows: Disk, Name, Job Number, Description,
Date.(9,999 records)

 

[John W. Vinson]

Fields for Table (Maps) are as follows: Drawer, Name, TMS Number, Date, Job
Number, Location, Subdivision, Block, Lot, Tract, Area, Surveyor, Revision,
Disk.(33,664 records)

Fields for Table (DCA) are as flollows: Disk, Name, Job Number, Description,
Date.(9,999 records)

What are the Primary Keys of these two tables?

What is the *logical*, real-life relationship between the two?

What real-life Entities (things, persons, events) are represented by each
table?

Does a given Job Number (say) always imply the same Name and Date?

It's very likely that you should NOT combine these tables, and that the
information should NOT be stored in both tables in the first place.

John W. Vinson [MVP]