Validation Help

[ajwposh]

I have 2 fields called confirmed and paid.

I want to have a validation which will only allow confirmed to be clicked when paid is selected. I put this validation "Confirmed"<"Paid" in the properties part of the table but it doesnt work.

Can anyone help?

 

[tkaplan]

on the form that the user will be entering the data in set the enabled or locked or visible property (or any combination) as false. then in the onselect event of paid, put
if paid = true then
confirmed.enabled=true
else
confirmed.enabled=false
end if

 

[ajwposh]

is there anyway i can do it in the table design?

 

[tkaplan]

i dont believe you can do it in the actual table.
i tried something like <=[Paid] but it returns an error that you cannot use multiple columns in a check.
is there a specific reason you want it in the table design? are you not going to be using forms??

 

[ajwposh]

im using forms but it has to be in table design if possible. I can get it so that the user has to confirm before they can pay but that was only by changing the arrow. If i cant do it then i will just have to code it like you said then

Thanks