data validation in a catagory

3.55K viewsTips and Techniques
0

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.

0

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.

0

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

Latest Questions

Wrap text in scripted buttons? 1 Answer | 0 Votes
Claculate product 2 Answers | 0 Votes
Sum by group in the same matrix 4 Answers | 0 Votes
Constrain input – varchar 1 Answer | 0 Votes