writing formula for "active"

[Tom_David]

I'm thinking I can use a 'formula' field to do this task. Can anyone help with the 'Formula' field... or is there a better suggestion. Thx.

IF
First 4 characters of a record in {Unit & Week} = First 4 characters of a record in {Unit Name} AND {2023 Fee Paid} is Checked, insert the amount in {2023 Maint. Fees} field.

Association Table
{Unit & Week} is not the primary field
{2023 Fee Paid} is a Checkbox

Maint Fees Table
{Unit Name}
{2023 Maint. Fees}

[TheTimeSavingCo · Accepted solution]

Hm, seems like something you need to use a linked field with a conditional lookup for instead of a formula.  Could you provide some screenshots of your tables please?

[Tom_David · Accepted solution]

Thanks, Adam. "...a linked field with a conditional lookup" was my second thought. Let me play around with that and if I'm still stuck I'll re-post.