Okay this is what I did. I added a field to the Fee Sch table that had the three fields concatenated. I added this as a text field and not a formula field so I could make it the primary key field. I think added a formula field on the main table that concatenated the same three fields together. I then did the relationship between the two and use those two fields as the reference field and key field. I was then just able to pull the fee sch as the a lookup field. It works perfect now. I wanted it to change based on when the fee sch table is updated, so I didn't need to use snap shot. Thanks.
