>That was my first idea. I just becomes difficult to keep that table in-sync. A business rule states; "Each task must have a fee for each space." So I have to code to make sure that happens. Also I just found out that there is a 3rd table "ConsultantService" that has to have a fee for each space. And another parent table "WorkOrder" has to have mirror image of those tables and wo Fee table has an additional field "SquareFeet".
>
I just love apps that are like peeling an onion <g>
>I keep running into the need to get just the Spaces or just the Fees for a specific contract, so I thought a ContSpace table would make it easier.
>
Either that or a 2 views one for fee info and one for the space info.
Insanity: Doing the same thing over and over and expecting different results.