2. PHPRunner General questions
  3. Linked Table Display Modification
This topic is locked

Linked Table Display Modification

 		7/8/2010 6:44:19 AM
PHPRunner General questions
S
 Spoils author

Hi this is a bit of a newbie question, I'm not sure if this is possible.
I would like to modify the display of linked table links,so that they are dependent on a drop down selection. I.e.
I have 2 linked tables to a parent table. I want to select from a drop down A or B and depending which one is selected I want a particular linked table link displayed.
Many thanks
A
 		ann 7/8/2010

Hi,
select field as dependent dropdown (Lookup wizard tab on theEdit as settings dialog on the Visual Editor tab).

Here is a tutorial (How to setup dependent dropdown boxes on Edit/Add pages):

http://xlinesoft.com/phprunner/php-database.htm
S
 		Spoils author 7/8/2010

Hi Ann thanks for the reply, I think I didn't explain correctly what Im trying to do.
I am designing a simple order tracking system. The Master table contains high level information such as shipment method (which is a selection of AIR or SHIP). Linked to this I have 2 tables AIR_DETAILS and SHIP_DETAILS. Because both of them have different fields I cannot merge them. So on the form, when Im creating the high level record I want to only display a link to either AIR_DETAILS or SHIP_DETAILS(for an inline add/edit) depending on which shipment method I have selected from the master table.
Im not sure if I can use an IF statement and where exactly I could put this in.
Many Thanks
Sergey Kornilov admin 7/9/2010

It looks like a bit of manual coding will be required to make this kind of dynamic link.
I would suggest to post your application to Demo Account and contact support team directly at http://support.xlinesoft.com sending your Demo Account URL. We'll see what kind of help we can offer in this regard.
P
 		PAGD 8/2/2010



Hi Ann thanks for the reply, I think I didn't explain correctly what Im trying to do.
I am designing a simple order tracking system. The Master table contains high level information such as shipment method (which is a selection of AIR or SHIP). Linked to this I have 2 tables AIR_DETAILS and SHIP_DETAILS. Because both of them have different fields I cannot merge them. So on the form, when Im creating the high level record I want to only display a link to either AIR_DETAILS or SHIP_DETAILS(for an inline add/edit) depending on which shipment method I have selected from the master table.
Im not sure if I can use an IF statement and where exactly I could put this in.
Many Thanks
P
 		PAGD 8/2/2010



Hi Ann thanks for the reply, I think I didn't explain correctly what Im trying to do.
I am designing a simple order tracking system. The Master table contains high level information such as shipment method (which is a selection of AIR or SHIP). Linked to this I have 2 tables AIR_DETAILS and SHIP_DETAILS. Because both of them have different fields I cannot merge them. So on the form, when Im creating the high level record I want to only display a link to either AIR_DETAILS or SHIP_DETAILS(for an inline add/edit) depending on which shipment method I have selected from the master table.
Im not sure if I can use an IF statement and where exactly I could put this in.
Many Thanks
P
 		PAGD 8/2/2010

Hi Newbie,
I've got exactly the same problem. Did you ever solve it?
Many thanks.
E
 		electromotive 8/2/2010



Hi this is a bit of a newbie question, I'm not sure if this is possible.
I would like to modify the display of linked table links,so that they are dependent on a drop down selection. I.e.
I have 2 linked tables to a parent table. I want to select from a drop down A or B and depending which one is selected I want a particular linked table link displayed.
Many thanks


This is probably possible to do without a lot of work <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=51547&image=1&table=forumreplies' class='bbcemoticon' alt='<<' /> I have done something like this.
I'm assuming that you have a master with two (or more) potential detail tables. Depending on a parameter in the master table you wish to have an option of displaying one or other links to the relevant detail table, or hide the link that's not relevant.
If the links are static (pre-defined in the table relationships tab), then you may be able to hide one or other of the links depending on data being entered by using the List page: Javascript OnLoad event. Then the normal ajax preview features will work. Exactly how you do this will depend on how the master parameter is defined. If you submit a support request, I'm sure they can give the exact code required.There are several examples of the javascript to dynamically hide links in the forums and maybe even the help.