Copied Fields Not Populating in Form

[LilZebra]

I am learning how to do relational tables, so I have some practice data as well as this is a Summer project for me.

The first table is a list of addresses, their property assessment values, a building condition rating, and whether that building is occupied or not.

The second table I have created so that I can add in next years' assessment and building condition ratings next year and the year after that, etc...

Instead of manually copying over all the assessment numbers all over again, all I did was to Copy the 1st table and only select the ID (primary key) and the Assessment Value. I then de-selected the primary key from the Assessment table and joined them up in the Relationships... box.

In the form that I designed, I have data from the first table -- ID, Address, Business Name, etc.. and in the second table ID, Year, Assessment.

My question is why doesn't the assessment values show up in the Assessment subform?

I am uploading a copy of the .odb file.

[UnklDonald418]

why doesn't the assessment values show up in the Assessment subform?

fmtAssesedValue is on the MainForm. In the form navigator drag fmtAssesedValue and its label onto the SubForm.

[charlie.it]

Ciao, you have to redo the set of properties of the column: