Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Doctor Doom
Starting Member
12 Posts |
 Posted - 2004-03-25 : 13:07:59
|
| Maybe a dumb question;Is it possible in Access (not via SQL), when creating a table, to put a validation on a field that depends on another field?For example: a user can put values in a field (lets say field nr.3), only if field nr.2 is not empty.If this is possible, where and how do I enter the code in Access?Thanks for your answers... |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-03-25 : 16:49:52
|
| that would be a table validation rule. in design view, right-click anywhere on the design grid and choose properties. then enter your validation formula, which can span columns.I don't quite understand your example, but if you want to say:"if ColumnA is null then ColumnB must not be null"you would enter a formula of:(ColumnA is not null) or (ColumnB is not null)- Jeff |
 |
|
|
Doctor Doom
Starting Member
12 Posts |
Posted - 2004-03-26 : 04:55:13
|
Thanks very much, jsmith8858! It's been a while since I worked with Access on a higher level.The first line in your answer was enough to solve my problem. |
|
|
|
|
|
|
field value in Acces, that depend on another field