Results 1 to 6 of 6

Thread: Master/Detail

  1. #1
    Join Date
    Apr 2004
    Location
    South Arica
    Posts
    125

    Unanswered: Master/Detail

    Is there any way to make an editable grid with master/detail records in the grid. I can display the records using SHAPE command, but am unable to find an easy way to edit the data.

  2. #2
    Join Date
    Feb 2003
    Location
    San Antonio, TX
    Posts
    31

    Re: Master/Detail

    Originally posted by Saila
    Is there any way to make an editable grid with master/detail records in the grid. I can display the records using SHAPE command, but am unable to find an easy way to edit the data.
    Three questions:
    1) What language?
    2) The _same_ grid?
    3) If the answer to 2) above is "Yes", WHY?
    (Or, in other words, Why not use two grids?)
    Ralph D. Wilson II
    email: rwilson@thewizardsguild.com
    URL: http://thewizardsguild.com

    "Any sufficiently advanced technology is indistinguishable from magic." A.C. Clark

  3. #3
    Join Date
    Apr 2004
    Location
    South Arica
    Posts
    125
    Visual Basic.
    Yes, have claims details:
    Medical labs, Claim No, ...

    Master records: Member ID, Problem, ...
    Detail records: Drug code, Price, Accepted...

    Can do it with seperate grids, but it would be prefered if its in one...

  4. #4
    Join Date
    Apr 2004
    Location
    South Arica
    Posts
    125
    I used the MSHFlex grid, setting the recordsource with the shape command, but the flex grid is read only. I have read about using a text box, and moving it around, but am not sure how to implement it... Any help would be appreciated.

  5. #5
    Join Date
    Feb 2003
    Location
    San Antonio, TX
    Posts
    31
    Originally posted by Saila
    Visual Basic.
    Yes, have claims details:
    Medical labs, Claim No, ...

    Master records: Member ID, Problem, ...
    Detail records: Drug code, Price, Accepted...

    Can do it with seperate grids, but it would be prefered if its in one...
    Regrettably, I am probably not going to be much help because I am not experienced in VB (my "eapon of choice" is Delphi ;-) ).

    However, just as a curiosity, if you display the master record and all of the detail information as one grid and you can let them edit it, wouldn't that still be a bit difficult to edit. I mean, how do you plan to handle things like adding a new record in the middle of the grid?

    Have you considered putting the various details on the tabs of a tabsheet type of object? You could present the Master Data as the upper portion of the form and then have the various tabsheets with data grids the presented the details of various kinds.

    Just a thought from the view of how the user may have to deal with the data.
    Ralph D. Wilson II
    email: rwilson@thewizardsguild.com
    URL: http://thewizardsguild.com

    "Any sufficiently advanced technology is indistinguishable from magic." A.C. Clark

  6. #6
    Join Date
    Apr 2004
    Location
    South Arica
    Posts
    125
    Hadn't thought of that, will give it a try and see how it goes. Thanks for the help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •