473,320 Members | 2,098 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Looking up Data in Access

I am a teacher and I am creating a database to help me record my parent contact that I make over the course of the year. I have made a table that has all of the students' information in it:

ID Number (primary key)
Student name
Subject
Period
Parent name
Phone number
Email address.

In my perfect world, I would have a second table that would be my contact home table:

Contact Number (primary key)
Student Name
Parent name
Phone number
Contact Notes (where I would write what I called about)

What I would like to do is create a form using my contact home table that I could have by my phone. Here I could type in the name of my student and access would fill in the other two fields (parent name and phone number) for me. I could call and leave some notes in the contact notes field. Any help would be great.

Thanks
Oct 13 '11 #1
2 1421
Rabbit
12,516 Expert Mod 8TB
Leave those fields out entirely. There's actually no need to repeat them. And instead of the student name, store the unique id (primary key) from the student table.

That way, you can join the two tables and get all the information without having to repeat it.

Expand|Select|Wrap|Line Numbers
  1. SELECT [student name], [parent name], [phone number], [contact notes]
  2. FROM students
  3. INNER JOIN contacts
  4. ON students.[ID number] = contacts.[student ID number]
Oct 13 '11 #2
NeoPa
32,556 Expert Mod 16PB
Perfect answer first time :-)

You may want to check out Marking a Post as 'Best Answer' if you're happy with it.
Oct 14 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: Frnak McKenney | last post by:
Back when computer dinosaurs roamed the earth and the precursors to today's Internet were tiny flocks of TDMs living symbiotically with the silicon giants, tracking access to data processing...
1
by: John Baker | last post by:
HI: Does anyone know a good manual or web site that addresses the development of applications using the Data Access Capability (HTM) in Access. I need to have something on a web site that, at...
0
by: Manystrengths | last post by:
I must warn all of you willing to help me that this is my first go at designing a functional data access page. Please bear in mind that we all start somewhere so if I should be asking the absolute...
4
by: Oyvind | last post by:
I'm working on a Windows forms/C# database application. My background is 6-7 years of VB 4 - 6, MS Access, VC++, mixed in with a lot of T-SQL and MS SQL Server in general and some OOA/OOD. ...
1
by: Johann Blake | last post by:
I am looking for a good solution on how to implement data access in an application so that there is a clean separation between the data access layer, the business layer and the GUI layer. I am...
5
by: jqpdev | last post by:
Hello all... I'm coming from a Borland Delphi background. Delphi has a specific component called a Data Module. In the designer the Data Module behaves like a windows form. A developer can...
6
by: Bob Alston | last post by:
I am looking for Access reporting add-in that would be easy to use by end users. My key focus is on selection criteria. I am very happy with the Access report writer capabilities. As far as...
3
by: Marc Gravell | last post by:
Kind of an open question on best-practice for smart-client design. I'd really appreciate anyones views (preferably with reasoning, but I'll take what I get...). Or if anybody has any useful links...
13
by: Alan Silver | last post by:
Hello, MSDN (amongst other places) is full of helpful advice on ways to do data access, but they all seem geared to wards enterprise applications. Maybe I'm in a minority, but I don't have those...
2
Curben
by: Curben | last post by:
Hello all, I am back with the new project i have had thrown at me. I need to make a DB with forms that are accessible by multiple countries on our network so this will not be "web based" per se. ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.