>>I just love apps that are like peeling an onion <g>
>
>Well, this one has made my cry a couple times. <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.
>
>I hadn't thought of that. I can use the flat table and a
select fk_space distinct
to get just the spaces or tasks. Cool. Thanks.
Can a task occur in multiple spaces per task per contract?
Cont --- Task
|
Cont_Task: fee Space
| |
---------------
|
Cont_Task_Space: cost