We have a Microsoft Access Database with an SQL backed that we use in house for managing our ticketing system. A former employee put it together, we love it, it has worked great for years.
I'd like to preface this with the fact that I myself don't know much about programming or Access, but just enough to figure things out as we'd like to add to or modify the program. Oddly, it has become fun and educational to figure it out on my own.
I am a little stuck on one item that we'd like to implement.
We have a form called "Phone Calls" which pulls records from a table called "CDR". Within this database, there is a field called "SRC" that contains the Caller ID number of a client who called.
I would like to be able to click on the "SRC" field within this form, and have a macro/vb script/something allow me to take the phone number that is in the "SRC" field, and copy it to the "Phone Numbers" field in another table called "Client Contacts", and allow me to associate the "SRC" phone number with an existing "Company" in the "Client Contacts" table.
Basically, what I'm looking to do is take the caller ID info of previous calls, and have an easy way of copying the phone numbers out of that table, and associating them with an existing company and phone number in our "Client Contacts" table. We have to be able to track phone calls for billing purposes, and it is extremely handy to be able to click on a client of ours in Access, and see all the related phone calls associated with that client. It would be easy to enter in if the client only called from one number, but that usually isn't the case.