Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Saving Multiple Values Into One Record of a Table
Message
From
20/12/2007 17:27:55
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
20/12/2007 17:21:00
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01276751
Message ID:
01276915
Views:
35
Yes, and only two fields would be common. The SetID and the Rule Type, or description of the rule. The SetID should never change and changing the description field should be simple as they will all share the same SetID. I think that sounds reasonable.

>>The more I think about this, I could have just one table. A grid could be used to filter to only show records belonging to the same set. Changes that are made would be made to the table.
>
>The one table would be the "detail table", then. This can be done, but then, in theory, any update you do to the "parent" information (the part that repeats is the same for the different details) would have to be updated to multiple record.
>
>A parent-child structure (i.e., seperate parent-child tables) is recommended for cases such as:
>
  • Invoices, with many details per invoice
    >
  • Students who register in several subjects
    >
    >etc., i.e., every time you might feel tempted to save multiple pieces of information in a single record.
  • Previous
    Reply
    Map
    View

    Click here to load this message in the networking platform