AnsweredAssumed Answered

Doubt on Relationships

Question asked by konakalla on Jun 25, 2012
Latest reply on Jun 25, 2012 by philmodjunk


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.

if[count(Account_Payee_AN_PAN::Account Number)>0]
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.