Since I'm just now starting to understand db normalization and using forms to lookup data from one table to reference it into another table, I now understand that my database has a lot of structural flaws, but, it's working. Or in this particular case, I'm getting it to work.
On a part of the database that is not too critical, (not a lot of interactive connections) I want to start to understand how I should have structured things.
My end desire is to have the Banks in the quniClassAndIndividual query display the bank letter instead of the primary key when I use the query in the report, rpt_Training_Employees.
In this Sample database that I've uploaded, I used to have a table level lookup in the AM_Operators table to the Banks table. I changed it to a textbox. So now, the bank column in the AM Operators table lists the primary key, which, as I understand, it should. My questions are several, since I'm making these changes:
1. Should I change anything relationally between the AM Operators and Banks tables?
2. Do I need to change any formats in the Bank fields (Text, Long Integer)?
3. What do I need to change in the query, quniClassandIndividual, in order to have it output the Bank letter instead of the primary key?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including: