Hi Everyone. I'm fairly new to Access and i am trying to build some better tracking for work. Currently they are using an Excel sheet, but Access will give them better management of the data.
So here is my question, after the user is done entering all the customer information on the form, i would like it to show the Primary key for that entry as they will need that for the quote tracking. A Drop Down will not work as there will quickly become hundreds to thousands of customers. I know they can just hit the forward button then the back button, but I'm trying to simplify this for the users. I was thinking a button with a VBA script that will do that, however I'm not sure what that script would look like or whether or not his is even the right approach.
My second question is setting up a search query for the users to find a customer. I know in the query I can add "*" before and/or after to return more results, is there a way to do that automatically when the user types in the search field when running the report. I want to be able to do this so the users can look up the customer ID's without having to remember how to spell their name.
I'm putting together basically a CRM that will track customers, quotes, and orders. Any other tips for this if anyone has any would be appreciated.
Thanks in advance and I'm really looking forward to getting better with databases.