Thanks 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!
