alain Posted November 28, 2001 Share Posted November 28, 2001 I'm working with 2 files, which I'll call A & B. A will be the master file. In A I have the "track#", "dept", "act_loss" fields. In B I have the "track#", "amt_rec" fields. I'm trying to establish a lookup field in file A (master) that would correspond to the "amt_rec" field in B. In file A I've defined a relationship b/w A&B based on the "track#" found in both files. When I create a lookup field in file A called "amt_rec" and specify the field in file B the field is blank. I thought I had everything set up correctly but it's obvious I don't. What am I overlooking? Any help would be much appreciated. Alain Link to comment Share on other sites More sharing options...
tlsparker Posted November 28, 2001 Share Posted November 28, 2001 Try clicking on the track# field (to make it the active field). Then, use the relookup command under records. Lookups will not retroactively place values in fields. If you want to auto-enter the looked up value when a new record is created, you can set that option in define fields. Link to comment Share on other sites More sharing options...
alain Posted November 29, 2001 Author Share Posted November 29, 2001 I tried the relookup by activating the "amt_rec" in file A and get an error message. "There are no fields that look up a value based on the field "amt_rec" which is bogus because when I look at my define fields in file A there is a field called "amt_rec" with a lookup based on the relationship that I have described in my previous post. I missing something but just don't know what. It's driving me nuts! Alain Link to comment Share on other sites More sharing options...
The Bridge Posted November 29, 2001 Share Posted November 29, 2001 quote: Originally posted by alain: I tried the relookup by activating the "amt_rec" in file A and get an error message. "There are no fields that look up a value based on the field "amt_rec" which is bogus because when I look at my define fields in file A there is a field called "amt_rec" with a lookup based on the relationship that I have described in my previous post. I missing something but just don't know what. It's driving me nuts! Alain I feel your pain; it took me awhile to grasp that the field you should be in when you do a Relookup is the field upon which the Lookup is based, not the field which is set by the Lookup. e.g. If Field A auto-enters Lookup information from a relationship based on Field B, then Field B is the field you want to perform the Relookup in. Like Tom Parker indicates, this field is Track #, since it is the field that forms the basis of the relationship. Hope this helps Link to comment Share on other sites More sharing options...
Vaughan Posted November 30, 2001 Share Posted November 30, 2001 FileMaker Pro never lies... Re-lookup using the field that the *relationship* is based on. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8207 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 accountSign in
Already have an account? Sign in here.
Sign In Now