mbrands
New Member
I have a form where projectleaders in my company can sent in statuschanges for projects. In order to do this i use a projectlist and a statuschangeslist
Structure:
*projectlist*
Field AA : Projectcode (text)
Field AB : Status (drop down with value 1,2,3,4,5,6)
*statuschangelist
Field BA : Current status (drop down with value 1,2,3,4,5,6)
Field BB : Projectcode (Cascading dropdown, filter projectcode based on status from projectlist)
Field BC : New status (drop down with value 1,2,3,4,5,6)
In the form for statuschanges i have one cascading drop down.
It filters the choices from the projectlist to the current status.
It all works properly, untill the status(Field AB) is changed in the projectlist. In the statuschange listview the field containing the projectcode (Field BB) is suddenly empty, while it is still stored in the database.
I think its because the cascading dropdown also filters the choices for the list view. The problem is, i would like to have the history present...so i would want to see the stored value in the list, and the cascading drop down to only filter the choices in the form.
How can i achieve this without a new listview?
Structure:
*projectlist*
Field AA : Projectcode (text)
Field AB : Status (drop down with value 1,2,3,4,5,6)
*statuschangelist
Field BA : Current status (drop down with value 1,2,3,4,5,6)
Field BB : Projectcode (Cascading dropdown, filter projectcode based on status from projectlist)
Field BC : New status (drop down with value 1,2,3,4,5,6)
In the form for statuschanges i have one cascading drop down.
It filters the choices from the projectlist to the current status.
It all works properly, untill the status(Field AB) is changed in the projectlist. In the statuschange listview the field containing the projectcode (Field BB) is suddenly empty, while it is still stored in the database.
I think its because the cascading dropdown also filters the choices for the list view. The problem is, i would like to have the history present...so i would want to see the stored value in the list, and the cascading drop down to only filter the choices in the form.
How can i achieve this without a new listview?