Doubt on Relationships
I am very new to the FileMaker. I am trying to build small bank app to learn FileMaker.
i have Payee table with Account Number_fk, Payee Account Number, Payee Name, PayeeList(value list) fields. i have another Account table with Account Number, Account type, .... fields. both tables have relationship with Account Number and Payee Account Number.
in one script i am verifying payee account Number is available in Account Number. if it available i am trying to add that number to payeeList in the below way.
Go to Layout[fund transfer]
in this way i am getting same PayeeList for all the Account's
how can i write script to get different PayeeList of each Account Number.
please guide me.