Automated values in a table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Radhika - 23 Jan 2008 01:53 GMT

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!

Reply to this Message

idtjes3 - 23 Jan 2008 02:30 GMT

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?

> 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
[quoted text clipped - 3 lines]
>
> Thankyou!

Reply to this Message