Reasons for decline requests Filemaker
I have a Request list view which manages requests for clients at my organisation. When an agency accepts a request, a script grabs the following from the user that is logged in $$CurrentAgencyId (_pkAgencyId), $$CurrentStaffId (_fkStaffId) - this is done just through a simple find request at start up. It stores the relevant variables in my Staff Request join table. However, I want to store reasons for declining a request, what's the best way of doing this?
I have created a Requests_Declined table would this be the best way to go about this with _fkAgencyId and _fkRequestId having a relationship.