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?

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:

tblClasses
pkClassID (Primary key Auto Number)
ClassName

tblClassDetail
pkClassDetailID (Primary Key Auto Number)
fkClassID
etc.

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

HTH

thank you

Don,

Did that resolve your issue ?

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

No Problem Good Luck with your project (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)