This topic is locked

Phprunner 9.8 not referring to "This dropdown is dependent on"

6/9/2018 6:02:43 AM
PHPRunner General questions
A
Abhijeet author

Dear All,
As the subject says, phprunner 9.7/9.8 is not referring to "this dropdown is dependent on" in the lookup clause. The dropdown link variable is ok and I have also linked it ok to the lookup table from the detail list table, and can be seen also in the list page of the detail table but the lookup table is not picking up that value from the table. I cannot use any additional security here or any session variables because one user is responsible for multiple company codes, so I found this dropdown is dependent on company code variable suitable in my case.
There is no security provided for the lookup table in the advanced tab and all records are available to every one depending on the company code, which is the purpose of using "This dropdown is dependent on"
Please help me. I am confused.

A
Abhijeet author 6/11/2018



Dear All,
As the subject says, phprunner 9.7/9.8 is not referring to "this dropdown is dependent on" in the lookup clause. The dropdown link variable is ok and I have also linked it ok to the lookup table from the detail list table, and can be seen also in the list page of the detail table but the lookup table is not picking up that value from the table. I cannot use any additional security here or any session variables because one user is responsible for multiple company codes, so I found this dropdown is dependent on company code variable suitable in my case.
There is no security provided for the lookup table in the advanced tab and all records are available to every one depending on the company code, which is the purpose of using "This dropdown is dependent on"
Please help me. I am confused.


Just to add further, I am using oracle 11g as back end database on windows server 2012 with xampp.

lefty 6/11/2018



Just to add further, I am using oracle 11g as back end database on windows server 2012 with xampp.


Are you saying there is no security available meaning you don't have security setup for groups as an example. Or are you saying you don't use any security on the project ? Then we might be able to help? Show us a screenshot of the lookup table with the test button pressed and the results. OR / How about autofill / readonly so it puts the value in automatically?

A
Abhijeet author 6/12/2018



Are you saying there is no security available meaning you don't have security setup for groups as an example. Or are you saying you don't use any security on the project ? Then we might be able to help? Show us a screenshot of the lookup table with the test button pressed and the results. OR / How about autofill / readonly so it puts the value in automatically?


Hello,
A Big Thank you for replying to my thread. Well I have found out the solution but I will post here the problem and the solution for everybody's reference.
The problem is as above, I have tested in the lookup wizard but the test was coming ok, when I changed the company code the part codes were changing in the test button, but when I ran the master detail table the part codes were getting messed up.
The solution:-
I was referring to the part master where the key columns were not defined properly, So I ticked every column in the table key columns as key columns and my problem got resolved. It is now showing the correct part codes for correct company codes.
Thank you once again all for viewing this.
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=85195&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

A
Abhijeet author 6/12/2018



Hello,
A Big Thank you for replying to my thread. Well I have found out the solution but I will post here the problem and the solution for everybody's reference.
The problem is as above, I have tested in the lookup wizard but the test was coming ok, when I changed the company code the part codes were changing in the test button, but when I ran the master detail table the part codes were getting messed up.
The solution:-
I was referring to the part master where the key columns were not defined properly, So I ticked every column in the table key columns as key columns and my problem got resolved. It is now showing the correct part codes for correct company codes.
Thank you once again all for viewing this.
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=85196&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />


Hello,
The problem for part was gone, now I am facing the problem for customers/ suppliers. But in that case even the above things didn't work. What may be wrong...
Please guide. Thanks in advance.

lefty 6/12/2018



Hello,
The problem for part was gone, now I am facing the problem for customers/ suppliers. But in that case even the above things didn't work. What may be wrong...
Please guide. Thanks in advance.


It has to be with the structure of your setup on master/details table . Although you can use many to many relationships I'm thinking this is not neccessary. Also are you using unique values checked in lookup wizard?
My idea is use advanced dynamic security and set admin only for your one user to set company codes table items. The details table can be filled in by autofill, based on your other relational fields. Set admin as admin and other users just to add other fields. Then for the fields you want only filled in by what admin put in admin on master table , use autofill to complete the form on the add page / edit page. you may need support to chime in here as this is confusing without screenshots. Whenever I want the users to have no option to fill in certain fields . I give them access to the table in lookup wizard but I autofill the field I don't want them to be able to cahnge. You can use view as readonly or you can use as lookup wizard field and still autofill and they will have to pick what is available to them. Therefore you are protected from everyone except admin. So you need an admin group and a users group in security setup.
If that works then:

As far as master / detail . That is another subject . Just setup in your tables and query.
I would suggest posting your project to the demo account here for support / ( see support options ) and they may be able to help you further. with your structure. If not PM me and add project and I will take a look at it.

A
Abhijeet author 6/13/2018

Hi John,
Thanks for your quick reply. Well I have advanced security already set up. I have reset all pages but still no luck. I would have posted to dummy account, but my database is oracle and it cannot be posted.
I will try a few things and then come back here.
Till then, stay tuned.
Thanks once again.
Kind Regards.