Linked Dialogs One to Many

[-Jinx-]

Re: Linked Dialogs One to Many

I submitted a bug report. This has to be messed up. I went and created brand new dialogs from very simple tables that don't even have foreign keys. I STILL get the error when trying to use navigation buttons.

I even tried converting the loadprimarykeys action script to xbasic, creating a function, and adding it to a button. Still doesn't work.



HOLD ON!

Click on your actionscripting for loading the primary keys and select "Convert to Xbasic" For some reason that works.

Update. ... not so much. It works so that you can navigate but it doesn't open the proper record initially.

[-Jinx-]

Re: Linked Dialogs One to Many

Hey,

Selwyn was nice enough to help us out on this. I tested it and it seems to work.


Open up the design mode on the second dialog (the one you want to call from the first).
Click on properties on the tree control and go to "Arguments"
Insert a new argument and call it "importid" or whatever. Set it to numeric and Set value at run-time.
SAVE the dialog (if you don't the next step won't work)


Go to the first dialog (the one you want to call the second dialog FROM)
Make a button and go to that buttons onclick event.
Select "Open a dialog component" (not the other ones to edit or whatever just the generic open)
Pick your second dialog that you want to call (the one you set the argument in)
Click on argument bindings and you should see "importid" in there. Double click on it and set it to the proper field in this dialog.
Save this dialog, your now done in here.


Go back to your second dialog and open up the ondialoginitialize event.
Put this line in there first: dim id as n = e.arguments.find("importid").data (that's where the argument value is stored)
Next put in your populate with data from table actionscript. Inside it pick "read from variable" and say that variable id contains the primary key.
Next put in the Load primary keys actionscript and convert it to Xbasic right away.
Go through the xbasic and remove or comment out this line: javascriptSetPrimaryKeys = javascriptSetPrimaryKeys + "{dialog.object}.navigateRecord('first');"


That SHOULD work. It worked in my testing.

Give it a try and let me know.

[cavj1]

Re: Linked Dialogs One to Many

Thank you Selwyn and Jinx but I may have to rebuild my Dialog as it doesn't really work. I've removed and added so many things in attempts to get this to work that I may be missing an item that needs to be removed. Right now the Dialog opens and I can navigate BUT it does not load only the related records.

I'll update more as I rebuild this.

Thanks again...Joe

[cavj1]

Re: Linked Dialogs One to Many

In your example are each of your Dialogs based off of one table? Or do I need to establish a relationship between Brokerage and Broker on the Brokerage Dialog?

Thanks
Joe

[-Jinx-]

Re: Linked Dialogs One to Many

Mine were just test components. One had the user id's and the other had user information linked by the user id.

I would think that you would just make your second dialog exactly how you would if it would stand on it's own. Bind all the fields normally. Then go through the steps above.

In the first dialog you would bind the argument to whichever field links the two together. For instance, my second dialog used the user_id out of the first so when I set the bindings in the "open dialog" action on my first dialog I set the importid argument to be bound to user_id.

Does that make sense? Without being in your head and looking at your stuff it's a little difficult.

[cavj1]

Re: Linked Dialogs One to Many

Sorry for the long delay. This still doesn't work and I think this is because Dialog's don't "Target" like a grid does. I think it is trying use the passed id against the wrong field.

The primary key for the Brokerage Table is Brokerage_Id

The primary key for the Broker Table is Broker_Id

The Broker table also contains contains the field Brokerage_Id that acts as the foreign key linking Brokerages and Brokers.

I think..I have to add the Broker_Id field to my Brokerage dialog and use that for the value to pass in the Argument.

[cavj1]

Re: Linked Dialogs One to Many

Okay, so that change loads data when the Broker Dialog is opened from the Brokerage Dialog. However, it is loading and navigating through all records and not those that related to a particular Brokerage. So not there yet....