In our Assets we have a text field called ROOM and we would like to know if it it’s possible to filter this field so it only shows the items / equipment in this room? This would also apply to any other text fields we have, such as Make and Model of devices.

I have looked at trying to use dependant fields, but this doesn’t work as expected. For a start, when editing the items in the dependant fields, it does not sort them alphabetical - that’s another issue to sort out.

Thanks