I have a database with several tables. One of them is for Contacts and another is for Projects that the contacts are associated to. I would like to build a form that would allow me to look for a contact and if they are new add them to the list. I...
I have a database with several tables. One of them is for Contacts and another is for Projects that the contacts are associated to. I would like to build a form that would allow me to look for a contact and if they are new add them to the list. I would also like to be able to change the project table from the same form.
Within the project part of the form, I would like to have a commit field for the customer. This will probably be linked to another table, but I would like to have the ability to add a new commit to this table. I would also like to see at least the last commit for that client. I was thinking of adding a button to my form that was linked to a macro that would add the existing commit, date, client name, and who the client spoke to, to the commit table. I think this would only allow me to see on my form only the last commit. I am not exactly sure how to add a button, or how to do a macro in access. I have done them in excel but not access.
I would also like to add a hyperlink on the form to the commit table that already has the customer's commits filtered.
Any help on any of the topics would be greatly appreciated. If you would like any other information let me know. The database is very large so I could not attach.
Thanks,
Joe