I have a database attached.
my problem is linking individual/group budget to Collections per month (QryCollections_Monthly andQrybudget_Monthly amounts)
for example Kyalimpa Rose is in Supplements section(SecID) but has targets(Budget) for KFM & Supplements. I want to pick monthly budget figure for KFM and match it with Collections for KFM and Supplements with supplemets in the frmCollections_Monthly(Form) or in a query.
See the details in the attached file.
Thanks for your help.