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.
|
lefty 6/11/2018 | |
Just to add further, I am using oracle 11g as back end database on windows server 2012 with xampp.
|
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?
|
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=':)' />
|
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.
|
A
|
Abhijeet author 6/13/2018 |
Hi John, |