If I understand your question, do you have a relationship where one year has many purchase orders. However the field for Related Year in the purchase orders table is not auto populating.
The solution is to set the key field of the year's table to be the year. Then make a new relationship where one year has many purchase orders but rather than letting the system create a new field comp related year, select in the drop-down the field that you have calculated the year in the Purchase Orders Table.
Alternatively if you don't want to kill your existing relationship you can take the field for related year in your purchase orders table and rename it to be called [year formula mirror]. And change the field tape to be a formula numeric and make the formula equal to that other formula field. I am assuming here that the key field of the year's table is a number but you may have made it a text field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
