find records from 2 databases

[Cin]

I am trying to create a report listing the activtiy on an account limited to a field on a separate database.

I have a database that lists all the accounts and information on the accounts. Some are Intercounty.

I have a transactions database listing the activities. The databases are linked through account name. I'm trying to get only the accounts that are intercounty. I tried to add a global field to the transactions and a script telling it that if intercounty in the list database is true to mark true to the field in the transactions database. the script does not work.

Any suggesstions?

Cin

[Fitch]

I don't get what you're using the global for, but I don't think you need it. Just put the related::Intercounty field on a layout in the accounts file and search on it.

[Cin]

I think I was trying to make it more difficult than it was. Thanks for the tip!

Cin