I am trying to create a Contact List that allows me to track incoming requests for support.
I anticipate the following fields:
ContactID
First Name
Last Name
Address
Phone
Fax
Date of Contact
Purpose of Contact
Action Taken
I expect that the same contact will call several times. Therefore, I don't want to have to input the Contact info everytime. If John Jones calls 3 times, I need to make sure that the contact John Jones is only listed 1 time, but that his calls (3) are listed each time.
I am having the hardest time figuring this out. I am just starting to learn Access in depth.
Thanks
I anticipate the following fields:
ContactID
First Name
Last Name
Address
Phone
Fax
Date of Contact
Purpose of Contact
Action Taken
I expect that the same contact will call several times. Therefore, I don't want to have to input the Contact info everytime. If John Jones calls 3 times, I need to make sure that the contact John Jones is only listed 1 time, but that his calls (3) are listed each time.
I am having the hardest time figuring this out. I am just starting to learn Access in depth.
Thanks