Jump to content

Help needed converting Access database to Filmaker


 Share

This topic is 6492 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6492 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.