Equijoin using global field
Posted on 2006-11-12
I have set up a commission table which has a fields Year_Written and Year_Paid. I have set up a global field in the same table called Assessment_Year. I have tried to set up an occurence based on this table, with equijoin on Commission_ID and Year_Written to global field Assessment_Year, to limit records to those where the Year_Written match the Assessment_Year. However, the dataset comes up blank.
If I experiment by matching the Year_Written with Year_Paid I get the record set I would expect.
Is it not possible to make an equijoin with a global field?