AnsweredAssumed Answered

Reasons for decline requests Filemaker

Question asked by KylerPhilips on Jun 22, 2015
Latest reply on Jun 29, 2015 by KylerPhilips


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.