Looking for Guidance

[ptrifile]

I need some guidance on creating a database to help track preference of contacts and contacts going out to people. Lets say that I have a list of 5 people all that have different preferences for how they are contacted(phone, email or text) and they all want to be contacted at different times and number of times throughout the day. Then I need to track via a form how, when and how many times they were contacted each day and then be able to create a report on if these contacts were made.

I’m not looking for someone to build this for me I am just having a hard time figuring out what the best approach would be and if anyone had any guidance they could provide.

Thank s in advance
Paul

 

[Remou]

I suggest three tables:

[tt]Contacts
ContactID > Primary key
Name
Etc

Preferences
PrefernceID > Primary key
ContactID > Foreign key
StartTime
EndTime
Required > Is a contact at this time required
Etc

LogFile
ContactID ) Combined for Primary key
StartTimestamp )
EndTimestamp
Notes
Etc[/tt]

http://lessthandot.com