due to presence of locked field unable to select possible values

[sudeepkm]

Hi All,

I've been facing this issue couple of days. The problem description is given below.

Please provide suggestions if any.

I've a table with fields as Category, Year, Quarter-Yr and Month

I've another table with one field Category.

There is only one value of field Category which is "A" present in both the tables.

Given below are the steps to reproduce the problem.

1. Select "A" from Field Category

2. Lock field Category

3. Select Year as 2013

4. Select Quarter-Year as Q3-2013

5. Select Month as Jul

Problem: Now if you try to select any other values of Quarter Year field then it will not allow you to select it.

For reference you can select the bookmark test1 in the document attached and try the above.

The only solution I've found so far is to break the association (field Category ) from the two tables.

Another solution is to keep the field Category unlocked but I cannot use it as per my requirement I've to lock the field Category.

[sudeepkm]

Any advice on the above mentioned issue ??

[sasikanth]

hi sudeep

i cannot say that this is the solution to the problem,

try to present LIST BOX style as LED , you may feel better than previous

[sudeepkm]

thanks for your reply. actually in the dashboard they are presented in a multi box.

I'm still not able to figure out why locking a field value would not allow to select possible set of values in another field.

When I use it unlocking the field it works fine.

[sasikanth]

HI Sudeep

Make your  script like following

temep:

LOAD Category  ,
     QtrYear,
     Year,
     Month
FROM

(biff, embedded labels, table is Sheet1$);
//tap:
//load 'A' as Category AutoGenerate(8);
tamp:
load distinct Category ,
  Category as Category1
   resident temep; 

Then Lock the Category1 Filed (it is same as Category Field) ,

and then see the selections ,

[sudeepkm]

Hi Sasikanth,

Thanks a lot.

I'm actually trying to find out the reason why locking a field is creating such issue.

As per my understanding I thought whenever we have a possible list of  values as a result of selection then you should be able to select them whether a field is locked or not.

From this issue I observed that when the field is not associated it works but if the field is a key field like the example I gave in the post that time it creates problem.

I already have a solution but I'm looking for a right explanation.

[Anonymous]

Hi Sudeep

     I am doing some selections in my list box , i am doing lock and i applied the action settings->document properties->field event triggers- >selected field and applied the action Lock field->in field place i have given the field name.when ever i am selecting unlock that unlock option is not working this is my requirement.

     when i closed my application and open it again i need to show the previous locked selection.

Thanks,

krishna

[sasikanth]

HI Krishna

PFA ,

there you will find the solution

let me know if you not

Thanks

Sasi