Re: List days capacity between two dates

My native solution is to create a middle table called Project Day Assignments

1 Project has many Project Day Assignments
1 Capacity has many project day Assignments.

That will allow you to summarize up to capacity to see where you have unused or overused capacity.

I would first get this working manually, and then we can discuss ways to make the process of adding the assignment records more easily.  A stating point is that for the drop down record to choose a capacity day to assign a qty to, to filer the drop down report for only where there is some capacity remaining.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------