I created a summary field (maximum) on a date field. I want to use this as the reference field in a reverse lookup between two tables( Projects and TSC disposition). This date summary field is not available as a reference field when I try to build the relationship, is this because its not a numeric field? Is there a work around? I want to use this date field to identify the latest record rather than the record id.