If you plan to usse real numbers, then simple constrant (99<xxx<1000) will do,
but if you plan on using codes lik 050 (zero-five-zero ) then you need field char, (leading zeroes will not displan on integer fields)
checks can be made using constraints, sql_constraints, onchange_method, etc...
pick what suit you the best:)
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 12/23/14, 6:54 AM|
|Seen: 356 times|
|Last updated: 3/16/15, 8:10 AM|