Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table with 2 parents?
Message
From
24/08/2000 14:34:08
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00408872
Message ID:
00408919
Views:
10
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform