Help w/ related files

[billybsr]

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")?

[Fitch]

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

[billybsr]

why didn't i think of that. guess i need 7 o.b. Thanks. BB