ContributionsMost RecentMost LikesSolutionsRe: Unique ValuesThank you so much!!Re: Unique ValuesQB is unable to find the Related field and displays "This table does not contain a field calledRelated Tree TREE#. To see available fields, click the Fields & Function dropdown to the right of the formula box." Unique ValuesI have two tables with a relationship. Table A provides the unique value of Tree_GPS_Coordinates to Table B. Table B uses the lookup value ofTree_GPS_Coordinates and collect data for fields Year and Height. Goal: I want to prevent any duplicate entries for trees in a given year. (e.g. Tree1 cannot have two 2017 measurements) Problem: Year field cannot be marked as unique because many trees will be marked as 2017, 2016, 2015 etc. Tree_GPS_Coordinates is a lookup field. Question: How do I create field formula to ensure there are not duplicate entries? I continually receive the message "This formula is incompatible with this field being marked unique. Please change the formula or uncheck the unique checkbox.