Scott
Each state has 2 completely differnt contacts(sites), one being a govorner's office the other being a differnt office, no way related; that's why the 2 of each state.
In the trouble table I have fields for: What the porblem is, another for how it was resolved, and a combo box which I...
Wals,
I am pretty much doing the exact same thing and trying to figure it out from my newbie status as well. I found a form that is along the lines or what we are looking to do, but the solution didn't work for me. Maybe you can figure it out and better relay how you did it in both...
RuralGuy,
The Duplicate fields were put in to store the information from the trouble ticket all in one place for ease in making reports. However if I knew how to get the combo box to propogate information to the text boxes on the form from a differnt table it would be a great starting...
Well I have about 110 contact records stored, and will have an endless trouble ticket log so it just seemed to make more sense to have two forms / tables. one to store the contact information, for use in the trouble ticket set and one purely for the tickets. Now just have to figure...
I came to this site in hopes of finding an answer to this very same problem. I'm new to access (3 days so far... but I learn fast).
I'm using MS Access 2002:
Problem:
Form1 / Table 1: Containts Contact information
Form2 / Table 2: Is a Trouble ticket system which has a dropdown box full...