The compliance questionnaire question builder has a good look up option except there is no restriction in place so if the user should be selecting only a subset, say 10 particular answers, but they get to access a whole table, they can be accessing 30000 records when they don't need it.

It would be nice to either
1. define an advance search for the look up, could be tough since all tables have their own fields
2. apply a SQL restriction

Some examples where there would be too long of a look up:
1. Trying to find a room but then gets all rooms
2. Trying to find an equipment of a certain type but then all equipment show up