If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > Delphi, C etc > Master/Detail

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-01-04, 15:37
Saila Saila is offline
Registered User
 
Join Date: Apr 2004
Location: South Arica
Posts: 125
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.
Reply With Quote
  #2 (permalink)  
Old 04-01-04, 17:19
RDWilson2 RDWilson2 is offline
Registered User
 
Join Date: Feb 2003
Location: San Antonio, TX
Posts: 31
Re: Master/Detail

Quote:
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
Reply With Quote
  #3 (permalink)  
Old 04-01-04, 17:26
Saila Saila is offline
Registered User
 
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...
Reply With Quote
  #4 (permalink)  
Old 04-01-04, 17:33
Saila Saila is offline
Registered User
 
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.
Reply With Quote
  #5 (permalink)  
Old 04-01-04, 18:47
RDWilson2 RDWilson2 is offline
Registered User
 
Join Date: Feb 2003
Location: San Antonio, TX
Posts: 31
Quote:
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
Reply With Quote
  #6 (permalink)  
Old 04-02-04, 05:29
Saila Saila is offline
Registered User
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On