alain

I've got a txt file that I import into FM4 which includes a field in mm/dd/yy format. It is being imported into a table witht the date field set to format as mm/dd/yyyy. The current year is showing as 1901. Any ideas what I have to do so that it imports it reflecting the proper year. TIA 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'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

I don't follow. I'm using a summary field. I tried using a calculation field and it would only display the total of the last record in the summary. It would never calculate the total of all the records in the summary. Only when I created a summary field would it give me a summary. Unfortunately it was the summary of all the records in file B and not the sub-summary of the found set of A. File A consists of the fields "track_num" "dept" "loss_amt" File B consists of the fields "track_num" "act_loss_ammt" "sum_act_los_amt" My link between the two files is "track_num" My report layout is in file A and includes the "sum_act_loss_amount" from file B. I thought about creating the report in File B but I would run into the same issue because I would also need a summary of the "loss_amt" from file A. How would I apply your calculation ID&""&Year based in the context I just described? I'm not familiar with it. Thanks, Alain

I have two files A & B. I have set up a one to one relationship between them. From File A I'm creating a report that includes a summary field on a field from file B. When I do a find and sort based on the "dept" field which resides in file A the summary field that comes from file B does not reflect the find of the set I get from file A. The summary field displays the total of all records in file B. I realize my problem is that I'm dealing with 2 different found sets. I'd like to know if there is a way that I could solve my problem. Unfortunately File B is imported on a weekly basis from another app. and there isn't a way that I could incorporate all the data into one file. Thanks, Alain

I have a value list that represent cause codes ex: ORD1, ORD2, MFG1, MFG2. Each code has a different meaning. Is it possible to have a drop down list that would include the cause code and show the meaning of the code but when selected would only leave the code as the data? In access this feature is caused a "combo box". Alain

Thanks for your help guys. Much appreciated. Alain

I've created a script that will put a user in find mode in a find layout. However if a user hits the cancel button in the middle of the find it leaves them in that find layout. What would be the best way to have the user return to the original layout if they hit the cancel button during the find? Thanks, Alain