Need help and advice designing a call center database.

[AbandonedRobot]

Thanks for the help. I've got everything sorted out now.

[June7]

Review https://www.accessforums.net/databas...eel-39471.html

Search forum on topics: call center, call tracker

Check out the MS Desktop Call Center database template. http://office.microsoft.com/en-us/te...010206879.aspx

Since SSN is the only link for the two datasets, I guess you will have to rely on it as primary and foreign key. Not ideal but appears you are stuck with it.

[AbandonedRobot]

Thank you very much for your reply. I'll review this information and keep plugging away.

[orange]

We currently do all of this in Excel.
??You currently have a similar application in Excel OR the application you took over from the other company is in Excel??

If you have it working in Excel, why are you changing to Access?
If your company has expertise in Access and Excel, how did you with limited Access experience get to develop the database/application in Access?

There must be more to this story than you have posted. Please clarify.