Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › How To Use Tap Forms to Match Donations to Projects
May 26, 2023 at 2:58 PM #49483May 26, 2023 at 7:03 PM #49484
You would want two forms. Houses and Donations. Your Houses form would link to your Donations form by adding a Link to Form field to your Houses form. I’m thinking maybe a
many-to-manyrelationship because you said a single donation could span multiple houses and a single house can have multiple donations. That’s the definition of many-to-many basically.
With this setup, you could click on any Donation and see which houses it was applied to. And inversely, you can click on any House and see what the donations were.
However, if you had a big donation which should apply to multiple houses, Tap Forms wouldn’t be able to split that single donation up to allocate a certain amount of the donation to different houses. You would just have to create multiple separate donations each with their distinct amounts and link them to the houses. But you could have some other field in your Donations form which would basically tie the smaller donations together, such as a unique Donation ID or something like that.
Hope that gives you an idea of how it could work.
BrendanJune 9, 2023 at 7:05 PM #49575
Brendan – thank you, and apologies for the slow reply. I’m going to try this and see how it works out.
You must be logged in to reply to this topic.