Looking for a way to do this, I have a field "contractor" and another field "call number". Here's what I want to do, based on "contractor", I want "call number" to have a certain input mask. May not be possible, but would entertain any ideas. For example, this is what I want to do.
If contractor = Kinko Juki, I want the format of call number to be A0001, A0002, A0003, and so forth.
If contractor = Ameku Juki, then I would want K0001, K0002, K0003 and so forth. The reason being is that there may be duplicate "call numbers" for each contractor. That being said, I can't make the field a primary field. Any ideas how to get through this little dilemna? Thanks in advance for your help.
Mike
If contractor = Kinko Juki, I want the format of call number to be A0001, A0002, A0003, and so forth.
If contractor = Ameku Juki, then I would want K0001, K0002, K0003 and so forth. The reason being is that there may be duplicate "call numbers" for each contractor. That being said, I can't make the field a primary field. Any ideas how to get through this little dilemna? Thanks in advance for your help.
Mike