Hi,
I have Departments, Location, Roles.
All three attributes having dependency on each other, How to reflect this in IT Shop.
Thanks.
Aad
Hi,
I have Departments, Location, Roles.
All three attributes having dependency on each other, How to reflect this in IT Shop.
Thanks.
Aad
Hi Aad,
Doing this using drop-down will require Web Designer customization since the data you have is dynamic.
An "easier" way to achieve the same would be to use request properties. You'll need to extend the ShoppingCartItem and PersonWantsOrg tables with the 3 FK columns to store UID_Department, UID_Location and UID_Org. Then, in the custom properties, you can start with Department as the first input. The second input can be Location, with a where clause something like "UID_Department='%CCC_UID_Department%'" (this means show only the list of locations where the department is what the user selected first). finally, you can use a similar logic to display the relevant UID_Org which the user can select.
Using the approach above you won't get drop-downs but it might be much quicker to implement.
HTH
Kunal