To clarify, acq.fund.year is an integer field, so "2022_" is not in the cards - and more to the point, nor is the likes of "2023-2024".
Regardless, I agree with the point that acq.fund.year (maybe renamed to acq.fund.fiscal_year or acq.fund.fiscal_period) should be a link to acq.fiscal_year. If we do that, I also think that acq.fiscal_year.year should be changed from an integer field to a text field. We should also give some consideration to adding an org owner column to acq.fiscal_year, as there's no guarantee that all members of a consortium would have the same fiscal period.
To clarify, acq.fund.year is an integer field, so "2022_" is not in the cards - and more to the point, nor is the likes of "2023-2024".
Regardless, I agree with the point that acq.fund.year (maybe renamed to acq.fund. fiscal_ year or acq.fund. fiscal_ period) should be a link to acq.fiscal_year. If we do that, I also think that acq.fiscal_ year.year should be changed from an integer field to a text field. We should also give some consideration to adding an org owner column to acq.fiscal_year, as there's no guarantee that all members of a consortium would have the same fiscal period.