Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table with 2 parents?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00408872
Message ID:
00408970
Views:
12
>>I would need a grid to show the user that would look like:
>>
>>Task Space Fee
>>
>>Schematic Plan Office $ .50
>>Schematic Plan Warehouse $ .20
>>Permit Drawings Office $ 2.20
>>Permit Drawings Warehouse $ 1.50
>>Field & Input Office $ .10
>>Field & Input Warehouse $ .05
>>
>>
>>
>
>What varies Cont x Space? I see all three involved, or pairs task x space and Cont x Task, but what associates on Cont x Space? Fee is dependent on what's done (Contract x Task) and where - there is no Cont x Space that I see. Cont x Task has a charge made up by ContTask x Space fees. I don't see anything that depends on Cont x Space alone...

I'm not sure what you mean by varies. Each contract has a list of Tasks that can be performed and a list of spaces those tasks are performed in. For each space / task combination there is a unique fee. Different contracts will have a different set of tasks and spaces.

In the expalme above a user does the task "Schematic Space plan" it will always be in both Office and WareHouse.

It's architecural services, if you asked us to design a manufacturing facility for you that consisted of 1,000 Square feet of office space and 50,000 sqare feet of warehouse, we would charge different rates for each type of space.
Roi
'MCP' Visual FoxPro

In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform