I am trying to create a dropdwon box that shows the pledge instalment number. I Have a databse that has customers, they can make donations, which can be connected to a pledge. Each pledge is broken up into instalments. So, in a portal in the cunstomer's card, I have a portal to their donations. I have a dropdown box from which I can select which pledge the donation is connected to. I have the folllowing relationships: Donations:_kf_CusomterID= donations_PLEDGES__viaCustomerID:_kf_CusomterID, from this I can create a dropdown box with a value list donations_PLEDGES_viaCustomerID::__kp_PledgeID, and include only related values from DONATIONS. This correctly shows all pledges to which the donation can relate. However, I'm now trying to show which instalment number to which it relates. I cannot seem to make the relationship work. I have the Pledges connected to a pledge schedule. How would I create a dropdown box in the customer's donation portal that shows the pledge instalment number? Do I continue the realtionship using the Donations:_kf_CusomterID= donations_PLEDGES__viaCustomerID:_kf_CusomterID, and create a realationship between the the donations_PLEDGES__viaCustomerID to the Pledge instalments?
To simplify: given the following relationships:
Customers -< Donations >- Pledges -< Installments
define a value list using values from Installments::InstallmentID, showing only related values starting from Donations. Once you have selected the PledgeID in the donation record, the relevant installments (and only the relevant installments) will become related and shown in the value list.