July 17, 200322 yr Hi gang! this one should be easy: 2 files (not related but can be if needed) ----file_1.fp5----- [Name] [Number] <--- value list to be use ----------------- -----file_2.fp5-------- [Number] [Available] (YES/NO) ------------------------ I have sorted/perfromed foundon file_2 based on "availability" and got an X number of records while the rest are omited.(ALL good so far)..now I want to your these "found" records ONLY in the value list for the file_1.fp5! How? thank you!
July 17, 200322 yr In file_2, create a calculated field, Case(Available="YES", Number). Base the value list on the calc field.
Create an account or sign in to comment