Hello, I have a probabaly simple question. On a certain value in one field, I want to denie data input for another field. Example I have internal and external customers. For internal Customers , there should be no data in another address field, for external customers, you can put an address in another field . Anyone knows a simple solution for this Many thanks in advance

Smoke and Mirrors Maybe?

I'm sorry, I did try to decipher your question, and maybe after a couple of more cups of coffee..., but I don't think it will help.

Try telling us again what you are trying to do.

Start with what you have now (use field names, it helps)

Next tell us what you are trying to accomplish.

It may also help us to know why?

Lee

Edited February 10, 200620 yr by Guest

if i am guessing right what you want could be done this way:

you could use the validate by calculation function in define fields dialog for your "another address field". the calculation could look like something like this:

customer_type = "External"

this way, entry is only allowed if the customer type is set to external