Good Morning,
I have a very simple database that I'm trying to set up for operators in my call center. I have one account that needs us to dispatch calls depending on the town they're calling from. If a customer is calling from Hartford, CT then the operator dispatch operator will need to call Yellow Taxi Cab Company for the customer to get them a ride. I have one table set up for the customers Information, and another table that has the City/State in one column, and the instructions for which Cab company to call in the next second column. I want to be able to select the city and have the taxi vendor information auto populate in another field.
I've tried to set up relationships, and write the VB code, but am unsuccessful. I either get errors about indexing and duplicates? Or, I am able to write the code (me.cbo.value = etc.....) but when I close out of VB my form does not do what I intend it to do. My level with Access is basic, I can learn it and understand it, but don't know EVERYTHING there is to know about building a database.