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
|
|||
|
|||
"Simple" Global Mailing List - 1 table or 3?
Hey all
Thanks for taking the time to read this msg. I am a "newbie" to Access, so bare with me here. I have a fairly simple request, but am struggling the basics of it, so any help would be highly appreciated. I am based in South Africa and the scenario is as follows: we have a fairly large mailing list, already in Access, which contains approx 80 k names around the world. South Africa consists of about 50 k, with another 20 k in Europe, and then the rest split around the rest of the world, including mainly America and so on. We print this entire mailing list 3 times a year to send our brochures to clients. My main AIM here, and you are probably wondering why I am trying to re-invent the wheel, is to provide CONSISTANCY to the Database. We currently have only one person editing the database, and you will be amazed at how many spellings there are of the word Germany alone!! And when you are posting from South Africa, you want there to be Correct Addresses. Our database currently consists of about 20 tables, as we have different tables for each category: South Africa A-Z, Foreign A-Z, Africa A-Z, US A-Z, Companies A-Z, Companies Foreign, South African Embassies, Foreign Embassies, etc, etc, etc NOW . . . I realise this can be put into one table, BUT I want to minimise the amount the data-inputter can type. Eg, I want: * Countries to all be pre-listed. * In South Africa I want all the Regions pre-listed. * In America I want all the States Pre-listed - and would like there to be the 2-letter state code based on the choice of state chosen automagically placed in the Postal Code field as a pre-text. As Embassies, Companies, Associations can all be boolean, they can be simple yes/no boxes. The concept I am struggling with is the following: If I have one table, I can't sub-select. If I have more tables, I am stuggling, using forms to apply the data properly. Any help would be much appreciated. Thanks and regards to all reading this. Richard |
#2
|
|||
|
|||
"Simple" Global Mailing List - 1 table or 3?
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I created a monster | Ben | Running & Setting Up Queries | 2 | March 16th, 2006 02:43 PM |
Multiple Options Group | Patty Stoddard | Using Forms | 19 | August 4th, 2005 02:30 PM |
Manual line break spaces on TOC or Table of tables | Eric | Page Layout | 9 | October 29th, 2004 04:42 PM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |