I'm working on a scheduling db for a factory; I've got portals showing what jobs are scheduled on what day - that works fine. What I need to do now is get a summary of how many pieces are being made by each machine. I can do a calculation based on the date relationship which shows how many pieces are being made altogether on each day, but cannot figure out how to get the relationship to discriminate between numbers in the Machine Number field (there are only six machines, so it's pretty simple.)

I guess what I'm trying to figure out is how to do a double relationship, so maybe I'm in the wrong forum - but I figure it is also a calculation.

If you want a summary, then why not make a summary report?

To get a summary of production by machine for each day, you could base the relationship on a concatenation of date & machine number. The machine number field may work better for you in a relationship if it is formatted as a text field. I find text fields are the most robust (you can always use TextToNum in a calcuation if necessary).

Please holler if I have misunderstood your question.