Table Views

[Former Member]

Hi Gurus,

I am working on the views and I have created one view which has got some inner join .....when I went to the view fields tab and I selected the fields that I need to include in the view it by default made all the fields as the key fields and I am not being able to chnage it as it is being greyed out....so can you please tell me how can I take care of this.

Thanks,

Rajeev

[Former Member]

You can not crate additional keys which are not avaliable in one of the tables in the Join.

So, if you view is based on the Z tables than try to change the keys in the tables and then try to include them in the view.

Regards,

Naimesh Patel

[naimesh_patel]

You can not crate additional keys which are not avaliable in one of the tables in the Join.

So, if you view is based on the Z tables than try to change the keys in the tables and then try to include them in the view.

Regards,

Naimesh Patel

[Former Member]

Hi,

I have got three tables and out of which one is the Z Table, when I tried creating the view...it befault made all the fields that I selected as the key fields....and what I want is I want to make only few fields as the key fields and not the all, so can you please tell me how can I do that .

Thanks,

Rajeev