Data collection

[JordanR]

I'm sorry if this isn't the correct forum to be posting in, but I wasn't sure where "I'm very familiar with Access, but I need to do X and I'm not even sure where to begin"-questions go.

I need to create a database that collects monthly metrics for an entire team.
So I setup tables

met_Metrics
Metric_ID
Metric
Assigned_ID

Reviewer
Reviewer_ID
Reviewer

met_Month
Month_ID
Month (formatted MMMM YYYY)
Metric_ID

I've sat and stared at this for far too long and I'm no closer. Each Metric will be assigned to a Reviewer. They will be responsible for entering the data for each Metric assigned only to them on a monthly basis.
Any suggestions would be greatly appreciated.

 

[JordanR]

Ok, I see what you're saying, but I'm still confused. (Really feeling like I'm lost in my own bathroom )
I was initially thinking of a form that would arranged like so:

                                 MetricMonth
         (populated drop box that jumps the user to a specific month)

MetricName   MetricValue
   Metric1         Value
   Metric2         Value 
       Etc.

Getting the dropbox to do what I want isn't really the question. Getting the Form laid out the way I want isn't really the question either. I guess it's the backend that's got me baffled.
Thanks for your help.

 

[JordanR]

Ah, I see where you're going, but it's not quite what I'm looking for. The idea is that UserA opens the form and there in front of her is a page that has a listing of all the metrics she's responsible for the month of January 2005 and next to it is a field where she has filled in the values for each metric she was responsible for providing.

She hits the dropdown box at the top and sees all the months of the year. She selects June 2005 and the form jumps. Now she sees a complete list of all her metrics with a blank text box next to each one for her to fill in the values for that month.

I have no problem making the form open up to view just her metrics. It's more an issue of getting the date idea to work, I think.

 

[JordanR]

I must be severly missing something.
I've attached a mockup of my database. After several hours, I cannot get it to function the way I was hoping.
Any assistance you can provide is REALLY appreciated. Thanks!

 

[JordanR]

Greatly appreciated, Pat.
Definitely some food for thought. I'll play with it for a day or so and see if I make any headway.
Thanks again.

 

[JordanR]

Ok, closer still, but now I'm getting an error when I try to do the insert. I figured the viewing is the easy part, I'll do that last and get the data input part down first.

 

[JordanR]

Ok, trying to take a different approach, but I don't know if this can even be done, since I can't say I've ever seen this, except in a cross-tab query, which isn't quite what I'm looking for.

Is it possible to have a form, where new records populate to the right, kind of like a spreadsheet setup?
The metric in the first column, who it is assigned to in the second column, the month of the year going across the top and each new record populates to the right so people can enter the value for the metric. Is this even possible?