By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,459 Members | 2,284 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,459 IT Pros & Developers. It's quick & easy.

Quick fix to unnormalized DB

P: n/a
I inherited a really ugly unnormalized DB that was originally built in
Alpha4 or something and then migrated into Access in about version
2.0. Quick and simple, it's Customers--(1,M)--Invoices. Is there an
easy way to reuse the reports that are already built? They all use
what was a single table. I'm thinking that if I change the
recordsource on each of these to a query that shows the relevant data
from each table, I should be good to go. right?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
TC
Sounds ok to me.

Say table 'T' originally had fields A-G and H-Z. Now you want to keep A-G in
T, but move H-Z to a new table, T2. You should be able to simulate the
previous table with a query like this:

SELECT * FROM T, T2
WHERE T2.pk = T.pk

'pk' is the primary key field of T. The primary key of T2 would comprise
*two* fields. The first would be, the same pk field from T1. The second
would be, some other field which serves to distinguish the multiple T2
records for a given T1 record.

To make the query updatable, use INNER (or LEFT) JOIN and ON, instead of
coma and WHERE.

HTH,
TC
"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...
I inherited a really ugly unnormalized DB that was originally built in
Alpha4 or something and then migrated into Access in about version
2.0. Quick and simple, it's Customers--(1,M)--Invoices. Is there an
easy way to reuse the reports that are already built? They all use
what was a single table. I'm thinking that if I change the
recordsource on each of these to a query that shows the relevant data
from each table, I should be good to go. right?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.