Good Morning Everyone,
We are transitioning from access to filemaker to track our daily payments for incoming membership and non-membership revenue. I am struggling to create through tables and/or scripts the following relationships and hoping someone can help me. Our fields are as follows.
Payment Type > Invoice Number > Name > Anniversary Month > Total Paid
What I want to happen is if someone selects one of 5 payment types in that field (New, Renewal, Directory, Online) only the corresponding amounts that it could be appear in Total Paid (1, 2, 3, 4) or if a different previous selection occured (5, 6, 7, 8)
Everytime I try I create it incorrectly removes all my tables. Thanks,