Many

[amigotto]

Hi,

I have a table of images - reciepts - related to a table of expenses. Some reciepts are related to more than one expense account and therefore more than one expense (one account can be reimbursed by another for certain expenses).

I've created a "filtered" layout which shows data from the expenses table via a relationship which matches the image name from the images table to the same name in the expenses table.

When I do a search for related records using a given account, the "payment numbers" in the records shown are not all from the account I've requested the search from. I know this is because of the way the related records are being sorted (there is no sort order that would always result in the correct payment number because there are too many accounts (7-8).

How do I have the "payment number" field display the proper value, ie. the "payment number" for the specific account I am searching, and not from another account?

Thanks,

Alvise