Help needed converting Access database to Filmaker

[heatherh]

Help!!

I am in the process of converting an Access database to Filemaker. In Access, you can use "Dlookup" to have the contents of a field automatically show up in a form. I know this is similar to the "Look-up" function of Filemaker, however, the lookup I need to occur is based on two matched fields (vs. the one matched field you set up in a relationship). More specifically, in one file I have a list of accounts with balances in each of those accounts by year. In the second file, I need to allocate that balance to different departments for that year. I would like the balance to automatically come up in the second file based on the year and the account. Please tell me how I do this!

FileMaker Version: 6

Platform: Windows 2000

[Reed]

with FM7 you can define relationships with multiple criteria, but in FM6, you can only match on a single field.... so to get around this you simply create a calculation field that concatenates the two fields you want to use, and use that as your key.

[heatherh]

Thanks for the tip!