Jump to content

Lookup on calculated field not working...


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

Recommended Posts

  • Newbies

I have in one file the Account Name and Part Number.

Substitute ( Match CM Name & Match Part ; " " ; "" )

In the other file I have a calculation from 2 tables, because in that file the Account Name is in a different table than the part.

Substitute ( DIT:: CM Name & MatchPart; " " ; "" )

So, the basics are that I need to match both the CM Name AND the Part Number, and all it has to do is flag the line item from the first file if there is a match on the criteria in the 2nd file.

I've gone over and over this, and I can get the lookup to work if it's just on one criteria - like one DB to one table in the other, but when I try to do it with these calcs, it fails. As a side note, I did have this same calculation set up in the old file (which I'm trying to get rid of by doing this), and it always worked there where there was only 1 table.

So, I'm thinking it's because my calc in the 2nd fle takes info from 2 tables.

Any advice would be great!

Thank you.

Rebecca

Link to comment
Share on other sites

  • 2 weeks later...

I never saw this post, sorry. You've found out that you can't index a field that involves a global or related field. So it can only be used as the left-hand key of a relationship, not the right-hand one.

Link to comment
Share on other sites

This topic is 7192 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
×
×
  • Create New...

Important Information

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