data validation in a catagory

3.60K viewsTips and Techniques

If a central database houses acceptable entries for items in a category (i.e. facility types) and the model allows the user to enter only needed items is it possible to validate the entry of items as it is for cells.


I think you would need to bring in the acceptable entries into the model somewhere to be used for validation purposes.


the concept is if I have 500 acceptable entries and I allow a user to enter items for a subset of those items thereby reducing the size of the model can I limit additions to only the acceptable entries.

Conceptually as I push this data to a central database, I want consistant selections than can be aggregated in SQL.

Latest Questions