AnsweredAssumed Answered

Relaed Tables

Question asked by rmycholuk on Jun 13, 2017
Latest reply on Jun 13, 2017 by Jaymo

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,

Outcomes