viewing child records w/ an alternatew form

[lmarini]

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

[forskare]

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

[Tom Cone Jr]

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

[lmarini]

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.

[forskare]

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

[lmarini]

RE: viewing child records w/ an alternatew form

The error message is "expected error".

[forskare]

RE: viewing child records w/ an alternatew form

Lou,

We really need to know more specifics.

kenn

[Tom Cone Jr]

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

[Tom Cone Jr]

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

[lmarini]

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.

[Tom Cone Jr]

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