brining together related data from two tables

[mttmwsn]

I used
Table Tools --> Database Tools --> Analyze Table
to eliminate redundant data. This split my main table into two tables. But
the savings are not great and now I want to bring the data back into the
same table.

Can I do this in Access, or do I need to use VB?

 

[mttmwsn]

"savings" of what? Splitting is not necessarily smaller or faster or ...,
but using a well-normalized relational database design will help ensure
the
integrity of your data. What's more important, accurate or fast?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I split my customer database into two databases, Customers and
CustomerAddresses. Since two customers may share the same address I had a
very small amount of duplication. Later I realized that spliting them is
not good design because the co-habiting customers might split, each to a new
address and now I want to go back to the origional plan.

 

[Jeff Boyce]

"savings" of what? Splitting is not necessarily smaller or faster or ...,
but using a well-normalized relational database design will help ensure the
integrity of your data. What's more important, accurate or fast?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Albert D. Kallal]

I used

Table Tools --> Database Tools --> Analyze Table
to eliminate redundant data. This split my main table into two tables.
But the savings are not great and now I want to bring the data back into
the same table.

Can I do this in Access, or do I need to use VB?

Just build a query that joins the tables back together. When you open that
query, the data will appear as if the data was one table like before you
split.

You can even edit, or export that table.......

In fact, if memory serves me correct, the analyzer usually makes a query for
you that looks exactly like the data before you split it...so, just use that
query.

You don't need code or anything else...just that query.....

The concept of "joining" the data using a query is the VERY essence of a
relational database...

That resulting query will look like ONE TABLE that can be edited, or
exported. It will *look* like one table, but in fact be two talbes joined.

 

[Jeff Boyce]

Can you simply replace what you have now with a backup copy of what you had
before?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[mttmwsn]

Yes, but I will loose data if I go to the backup copy.