Question Required Field based on another field

[bobburg]

How do I make a field required but only when another field in the same table has data?

 

[bobburg]

Thanks for your reply.

I need to do it at the table level. Any idea how that is accomplished?

 

[gemma-the-husky]

is this an access database - if so, you cant do it - since you can only set a field as required or not. (not required conditionally)

what uncle gizmo meant was

why can you not control this at data input stage? ie via a form?


the issue with these things is always that once data is entered, you then have to manage the process so that the dependant field continues to obey the rule

ie
what happens is you delete the contents of field A
what happens if you delete field B
what happens if you enter something in field B, while field A is blank/null
does it matter whether field a is blank (zls) or blank (null)

 

[evanscamman]

I believe this is possible at the table level.

http://allenbrowne.com/ValidationRule.html

Evan