ContributionsMost RecentMost LikesSolutionsRe: Using data from one table numerous times in another tableThanks for the detailed response! Should have gone down this road from the beginning; I have one table for employees, I created relationships for a number of other tables, that allows employees to to enter time off, expenses, recognize other employees for internal awards, etc. I'd like to have a relationship setup with an additional table called KPI's, that would allow an employee, under the employee tab, click "add KPI", which would (as the very least), allow them type in the name of their KPI (for example, x-number of demos), indicate the final "result" (a simple text field would suffice, to accommodate different types of goals), and then a drop down to select whether it was green, yellow, or red, as far as a threshold. I would also need to then be able to pull a report to show what everyone's goals are, their result, and whether its Green, Yellow, or Red. I think you're proposed solution could get me there, but I'm a self-taught, novice app-builder so it may take some playing around. Thanks again!Re: Using data from one table numerous times in another tableThe goals are the same usually month to month, but it is possible it changes from time to time, but they would always be either green, yellow, or red. Does that answer the question?Using data from one table numerous times in another tableI'm struggling with table relationships. Here's my scenario; I have monthly goals for every employee. At the end of the month, I'd like employees to go in and tell me whether the goal is Green, Yellow, or Red. I need to be able to pull a report/view that shows how many of each "status" per month, as well as per employee over a given time period. What is the best way to set this relationship up?