Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help about OneToMany form designs !!!
Message
From
08/02/2005 12:39:23
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00984620
Message ID:
00984777
Views:
29
>Ok I understood,
>if so can you make for me a simple prototype about your pageframed solution ? i have no idea that how should i do ...
>
>TIA

I find it difficult to make a prototype; I have invested a lot of time making it work within the framework. But I will give you a brief description.

Put a PageFrame on a Form. In each Page of the PageFrame, put a read-only Grid in the top half, and editing controls (especially Labels and TextBoxes) in the bottom half.

Make the buttons like "Add", "Delete", "Next record", etc., apply only to the active Page. You will have to store information in some place, what alias is related to what page.

I do not recommend linked grids for the child part. To show only records related to the parent table, you have several alternatives:

  • SET FILTER - limited to tables of about 20,000 records. For larger tables, it will be too slow.
  • SET KEY - limited functionality, because you are restricted to the order defined in the controlling index.
  • Parameterized view - flexible and fast.

    I recommend the last option; but you may want to start experimenting with SET FILTER first, because it is a little simpler.
    Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
  • Previous
    Next
    Reply
    Map
    View

    Click here to load this message in the networking platform