AnsweredAssumed Answered

Retrieving information from a related table

Question asked by pdoak_1 on Dec 17, 2010
Latest reply on Dec 17, 2010 by pdoak_1

Title

Retrieving information from a related table

Post

Background Info: I am using the following

  1. Filemaker pro Advanced 11
  2. Mac OS X 10.6.5
  3. Single user mode
  4. I have been using Filemaker Pro for a couple of months

I have the following three tables:

  • Accountstatus - shows client account balances by date
  • ClientAccounts - shows client accounts, client IDs
  • ContactTable - shows client information by Client IDs i.e. name and address

A client ID can have multiple accounts associated with that ID

I have set up the following relaitonships:

Accountstatus:ClientAccount = ClientAccounts:ClientAccount

ClientAccounts:ClientID = ContactTable:ClientID

I have produced a report from the AccountStatus table and wish to retrieve the corresponding information regarding a client account from the ContactTable.  The only information that I am trying to retrieve is the client name for that account but although it the layout produces some names it does not show all the names although I know them to be in the ContactTable.  Why would that be?

Outcomes