[AccessD] Another normalization question

Separate table with FK back to the institute and 'contact name' and 'contact
title'

Multiple entries allowing multiple numbers per person, and multiple people per
number and person associated with multiple organisations 

Maybe an additional keys giving a priority on number for person, and priority
for organisation 
Also times/dates/days  that numbers apply, or do not apply

You can have a person working at multiple organisations doing different types of
tasks at different times 
Manager at one place, volunteer at another

Basically - a searchable text field - or maybe 2 so the contact times can be
separate from other notes.
Setup a standard  set of prefixes for the search to indicate Available weekDay
MTWTFSU Periods from-to yyyymmdd-yyyymmdd
  
Also  email contacts #codes facebook website - so many ways to contact people
now-days, but you basically need to know who - for what  where and then the rest
will be ok as text with pre-assigned prefix codes to let the reader know how to
use the 'value'.

And some of my clients have contact email and answerphone landline.
Others have my cell number - not answered when I'm actually working with a
client.
Others get the personal number - is answered even if I'm working, or it's later
than 7pm
And I only have 1 'employment' at the moment.

I used to be 'distribution manager' for several apps, systems support & DBM for
mainframe, PC and network support and maintenance team leader as well as doing
onsite liaison.
That was real 'fun' especially when I found out the mainframe ops had the phone
numbers of my local alehouses - not even safe of a Friday evening! 

JimB


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, September 16, 2014 8:14 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Another normalization question

I'm still working on the animal tracking database. It's going Okay, but I
don't have a lot of free time to work on it. ;)

Right now I'm hashing through institution contacts and phone numbers. I
think, for the most part, that most phone numbers will belong to the
institution, but maybe not -- what if the institution has more than one
contact and each has a number? On the other hand, if I relate the phone
number to the contact and the contact leaves, I lose the phone number,
which might rightly belong to the institution.

You know, looking back... I can't remember how I handled this in the past.

Susan H.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com