I select A in location field it should only display a,b,c in category field if I select B then it

[unrecognised007]

I have two fields location and category in location I have A and B and in category I have a,b,c,d If I select A  in location field it should only display a,b,c in category field if I select B then it should display a,b,c,d in the categoy field how should I achieve this ?

[Dr Atul G- LNG]

Hi @unrecognised007 

Is there a relationship between Location and category do you have categories in the location table? If no then you need to write the client script and hardcore with sysid  the value of location and then based on that same need to do for categories.