- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 15, 2023 12:14 PM
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}
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 15, 2023 10:25 PM - edited ‎Apr 15, 2023 10:25 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 16, 2023 06:05 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 15, 2023 10:25 PM - edited ‎Apr 15, 2023 10:25 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 16, 2023 06:05 AM
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.
