If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table Design
Greetings,
We have an Access database that was originally designed back in Access 2.0 days. It's since been added to and convert numerous times; today it's an Access 2003 database. My question has to do with table design and relationships. We have one table with name, address, city, state, zip type of information. We have a need to associate multiple addresses to a name (e.g. home address, business address, etc.). It seems that we need to move the address information into its own table and hook address records to name records. This database has many reports. The reports are usually query based and some use the address information. Is there any way to relate the tables so that we don't have to change the queries/reports? Or will we have to recode every query with JOINS? Or is there a better way to do this? Any help would be great. Thanks. |
#2
|
|||
|
|||
Table Design
Since you have multiple addresses pername under new arrangement, you will
have to think of *which* address to use in the existing simple single name - single address arrangement. For example, you may decide to mark one address (out of many) for each name as the default address and use this for the existing Reports. In this case, you only need to modify the Queries being used as the RecordSource of the Reports. OTOH, you may need to include some or all addresses per name then obviously, the Reports & their RecordSources need to be changed substantially. -- HTH Van T. Dinh MVP (Access) "Rod Bayron" wrote in message ... Greetings, We have an Access database that was originally designed back in Access 2.0 days. It's since been added to and convert numerous times; today it's an Access 2003 database. My question has to do with table design and relationships. We have one table with name, address, city, state, zip type of information. We have a need to associate multiple addresses to a name (e.g. home address, business address, etc.). It seems that we need to move the address information into its own table and hook address records to name records. This database has many reports. The reports are usually query based and some use the address information. Is there any way to relate the tables so that we don't have to change the queries/reports? Or will we have to recode every query with JOINS? Or is there a better way to do this? Any help would be great. Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
Modifying table design breaks Append query | MKH | Database Design | 2 | June 15th, 2004 04:05 PM |
resize table from A4 size to A5 | ims | New Users | 3 | June 9th, 2004 01:05 AM |
Table design question - advice needed | David | Database Design | 3 | June 8th, 2004 02:21 AM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |