Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Access database query
Name: mullen103 Date: November 9, 2007 at 13:11:10 Pacific OS: 98se CPU/Ram: p 2
Comment:
Hi
I have a reference table created from global adress list in outlook it has alias in it. I have created a table and want user to input alias and it automatically fill in data for surname and Forename.
Is this posible I do not want to link my tables to the address list as there is data that will not be used
Name: Jennifer SUMN Date: November 9, 2007 at 16:25:41 Pacific
Reply:
Where are the names stored? Do you want the user to enter the data into a field, or into a form based on a query?
Life's more painless for the brainless.
0
Response Number 2
Name: mullen103 Date: November 10, 2007 at 02:14:16 Pacific
Reply:
The names are stored in another table just a reference one. I want the user to input a number in one field then the surname and forename appear automatically in the fields in the tables. I have done no forms or queries yet.
www.mullen103.com
0
Response Number 3
Name: Jennifer SUMN Date: November 10, 2007 at 14:12:34 Pacific
Reply:
Proper database structure is to store data in one table only. Why do you want the data duplicated? Redundancy is not really good database design.
What exactly are you going to do with the database?
Life's more painless for the brainless.
0
Response Number 4
Name: mullen103 Date: November 11, 2007 at 05:19:02 Pacific
Reply:
I would not really call it redundancy as its not linked to the database. I do not want to link it because there are names that are not going to be used in the database.
www.mullen103.com
0
Response Number 5
Name: Jennifer SUMN Date: November 11, 2007 at 15:10:03 Pacific
Reply:
What isn't linked to the database? Perhaps you could be a little more clear exactly what you're using the database for, and what the ultimate goal is.
Summary: I am looking for help and info to convert an Excel Spreadsheet to an Access Database (MDB) Any help or guidance would be great! Thanks in advance for the help ...
Summary: I have a supervisor who's sharing an access database with 5 people in her unit,she can write to it and make changes,but the other 5 users can't write to it, they can olny view it. Any suggustion?...pl...
Summary: Hello All, I work as a programmer for a direct mail company. Here is my problem: I am developing a Access (.mdb) database for a company that we just mailed tax forms for to there customers. The com...
0 
MS Access SQL query
