Using data from one table numerous times in another table
I'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, Y...
The 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?