Alpha Video Training
Results 1 to 11 of 11

Thread: viewing child records w/ an alternatew form

  1. #1
    Member
    Real Name
    Lou Marini
    Join Date
    Feb 2001
    Posts
    136

    Default viewing child records w/ an alternatew form

    I am having a bit of a problem fetching through records within a set. I have a set which links consist of a master parent databse of patient names. I have a treatment notes database which is linked to this parent database through their patient number . I also have a movie database which is linked via the patient number.

    In version 1.02 I was able to do a card popup command & view child records through an alternate form within the set(card_popup("form_viewer", "USE=~MOVIE~ FETCH_STATE"). This would bring me to the correct patient which I was viewing with an alternate form within the set.

    Using this similar command in version 4 , the new form will open but no child records are displayed. In fact it sees no child records at all. Any suggestions?


    Below is the structure of the set



    Lou database is the master databse



    The Dictation db is linked as follows: //Parent linking fied =str(number)//Child Linking field=STR( PATNUM )+INVERT( CDATE( DATE ) )

    The Movie db is linked as follows: //Parent linking field= number// Cjild Linking field = number



  2. #2
    "Certified" Alphaholic forskare's Avatar
    Real Name
    Ken Nordin
    Join Date
    Apr 2000
    Location
    Walker, MN
    Posts
    7,545

    Default RE: viewing child records w/ an alternatew form

    Lou,

    Not sure I understand what is is you're attempting to do but I'll take a try at it.

    I think you want to call up a form to show records pertinent to the patient. If that's the case, I can think of a couple of ways to do it, 1) use a tabbed suboform or 2) a button to show another form. That button can be created with the button genie to show only precords in bioth tables that match the patient_id number.

    I don't understand why you need a link expression as the patient_id number ought to work.

    kenn

  3. #3
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,311

    Default RE: viewing child records w/ an alternatew form

    Lou,

    Tell us about the form you are trying to display. Was it based on the same set, or just one of the tables in your database?


    Give us the details on the 'similar command' you use to open the form. Show us the specifics.


    -- tom

  4. #4
    Member
    Real Name
    Lou Marini
    Join Date
    Feb 2001
    Posts
    136

    Default RE: viewing child records w/ an alternatew form

    I attempted using the button genie to open the new form.I selcted only those records that match the patient number. I get the following error as depicted in the enclosed file. I also enclosed the script which is attached to the button in version 1.02 which works just fine.

  5. #5
    "Certified" Alphaholic forskare's Avatar
    Real Name
    Ken Nordin
    Join Date
    Apr 2000
    Location
    Walker, MN
    Posts
    7,545

    Default RE: viewing child records w/ an alternatew form

    Lou,

    I believe there is some differences in the Xbasic between v1.02 an v4. I tried to open the attached file but nothing showed in Acrobat Reader.

    What did the error message say?

    kenn

  6. #6
    Member
    Real Name
    Lou Marini
    Join Date
    Feb 2001
    Posts
    136

    Default RE: viewing child records w/ an alternatew form

    The error message is "expected error".

  7. #7
    "Certified" Alphaholic forskare's Avatar
    Real Name
    Ken Nordin
    Join Date
    Apr 2000
    Location
    Walker, MN
    Posts
    7,545

    Default RE: viewing child records w/ an alternatew form

    Lou,

    We really need to know more specifics.

    kenn

  8. #8
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,311

    Default RE: viewing child records w/ an alternatew form

    Lou,

    I finally got around to opening the PDF you attached to an earlier message. I'm not familiar enough with vers. 1 scripting commands to explain what you're seeing. However, I can send you an easy example of how to do it using vers. 4 syntax. Standby.

    -- tom

  9. #9
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,311

    Default RE: viewing child records w/ an alternatew form

    Lou,

    Here's an easy way to do it with Vers. 4 syntax.

    This approach embeds a filter in the properties of the called form. The filter relies upon a variable, which is passed to the form when the form is opened.

    -- tom

  10. #10
    Member
    Real Name
    Lou Marini
    Join Date
    Feb 2001
    Posts
    136

    Default RE: viewing child records w/ an alternatew form

    I want to thank you in advance for your help. I tried using the parameters of the zip file you downloaded but unfortunately it did not work.It said it could not find the parent form number. I enclosed a zip file of my database & possibly you can offer an explanation.
    If you open the daily form & attempt to click on the button on the form called movie, you will see that it does not go to the particular patient number but defaults to the first record number.I tried it using a form attached to the set and a separate form which is not attached to the set.

  11. #11
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,311

    Default RE: viewing child records w/ an alternatew form

    Lou,

    I had trouble with your forms.

    You have two named exactly the same. That's bad business and will cause Alpha Five confusion without exception.

    Some of your forms were stored using an older format.

    Your Daily form contains a series of actions using older xbasic syntax, with which I'm not familiar.

    So, rather than try to 'fix' your forms, I struck out on my own.

    I created a new form based on the Dict1 set and called it Test1.

    I then created a new form based on the Movie table and called it Movie2.

    Buttons are now in place on Test1 to open Movie2. One enables edits of all Movie records. The other limits the view to those which are linked to the Lou table, through the Number field.

    Study the Variables defined in both forms.

    Study the properties of the Movie2 form, especially the filtering expression.

    Study the OnPush event scripts for the two buttons on Test1.

    Have fun!

    -- tom

Similar Threads

  1. Child records staying on form
    By GregOnline in forum Alpha Five Version 6
    Replies: 2
    Last Post: 03-24-2005, 10:24 AM
  2. Child records shown as form - Not browse
    By Robert Rough in forum Alpha Five Version 5
    Replies: 8
    Last Post: 09-09-2004, 03:45 AM
  3. form to enter/edit child records
    By French in forum Alpha Five Version 4
    Replies: 7
    Last Post: 04-30-2001, 02:11 PM
  4. Viewing deleted records before packing
    By George Pulley in forum Alpha Five Version 4
    Replies: 2
    Last Post: 04-11-2001, 10:25 AM
  5. Child Records?
    By Bruce MacPherson in forum Alpha Five Version 4
    Replies: 2
    Last Post: 06-15-2000, 10:08 PM

Bookmarks

Posting Permissions

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