A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Consolidating contacts.



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old May 13th, 2009, 11:33 PM posted to microsoft.public.access.tablesdbdesign
EdEarnshaw
external usenet poster
 
Posts: 2
Default Consolidating contacts.

I'm in the process of designing and creating a database to keep track of
people, much like a contacts database, but a little bit more complex.
Currently I have it planned so that there is a students table and an agent
table. Ultimately I need to keep track of emails from Outlook through a
linked table containing the emails. (So I'm filing emails digitally rather
than printing them off.)

My question is if it is possible to consolidate the agents table with the
students table.
The students table contains a lot more information than the agent table
So I was not sure if it would be practical to combine the two directly and
have many of the fields (those that are agents) end up remaining null.
Any help would be appreciated. Please let me know if any clarification is
needed.

Student table fields are as follows:
StudentID (autonumber)
AgencyBranch
LastName
FirstName
DOB
PermanentAddress
PermanentTelephone
Mobile
FaxNumber
E-Mail
ParentE-mail
CountryOfCitizenship
AlternateAddress
AlternateTelephone
DateCompleteApplicationReceived
ApplicationReceivedFromAgency
ApplicationReceivedFromStudent
Photo
StudentType
Session/SemesterOfInterest
Session/SemesterofInitialEnrollment
IDNumber

The Agents table contains the following fields:
ContactID_AN
ContactType
AgencyBranch
LastName
FirstName
PhoneNumber
FaxNumber
MobileNumber
E-mail
Photo
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.