Automated values in a table

  • Thread starter Thread starter Radhika
  • Start date Start date
R

Radhika

I have a table which inculde two fileds. Field 1 called "Injection" is a
Yes/No box. Field 2 called "#of Injections" is a number column. I want to
have an automated function, where if "No" is selected in "Injection", "# of
Injections" automatically fills in a value of "0". How do i do this in a
table?

Thankyou!
 
Hi
What if you just made the default value of the second field "0" that way
you wouldn't have to worry about it if its " No" and if is "Yes" you would
have to edit it anyways with a quantity right?
 
Back
Top