April 12, 200817 yr Newbies i have 2 files. the 2nd file has "symbol", "price" , and "date" as fields. a symbol will have different prices at different dates. the 1st file has a "symbol" and "date" field and needs to look up the "price" corresponding with both. I have always done this by relating to one field in the 2nd file. How can i relate to 2 fields ("symbol" and "Date")?
April 12, 200817 yr With FileMaker 7 and newer it's a simple matter of adding fields to the relationship. In FileMaker 6 you'll need to create a calculated field in each file that combines the two fields, and base your relationship on that. E.g.: symbol & "_" & date
Create an account or sign in to comment