Jan 5 2009, 01:15 PM
I have created a form to view children's details. Due to normalisation, instead of the class name, the class ID is input. How do i get the actual class name to come up instead of the class ID? Do i simply add another field?
Jan 5 2009, 01:30 PM
What is the structure of the table you are using to input the Class Name ? Are you using a combo box ?
I will assume that you have something like the below:
pkClassID (Primary key Auto Number)
pkClassDetailID (Primary Key Auto Number)
Using tblClasses as the Row Source of your Combo box you would have a Column Count of 2, Column Widths of 0;2.0
Use the wizard to build your Combo and when asked what field to assign to use fkClassID your Form of course would use tblClassDetail as its Record Source
Jan 5 2009, 02:06 PM
Jan 5 2009, 02:07 PM
Did that resolve your issue ?
Jan 5 2009, 02:26 PM
I think so, I understand what to do, if it does not work I will let you know.
Thanks so much for your time and help
Jan 5 2009, 02:39 PM
No Problem Good Luck with your project
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here