Page 1 of 1

Validation Rules

PostPosted: Thu Jul 06, 2006 8:44 pm
by Mariam
Hi Red1,
I would love to have a combobox with all the purchase orders that i have. I guess i got something missing in my concept about the validation rule thing.
I'll be glad if you have some hints that may help me to do this.
thanks in advance for your concern,

PostPosted: Fri Jul 07, 2006 7:01 am
by red1
What did u setup in your validation rule? There are ready samples in GardenWorld, so u just have to refer to them.

PostPosted: Sun Jul 09, 2006 4:10 pm
by Mariam
Thanks for replying.. You mean that there is a validation rule helps me to show all the Purchase Orders that were ever created in the system and i should use it?
because i wanna have a combo-box with all purchse Orders IDs that were crerated in the system.
Does this exist?

PostPosted: Sun Jul 09, 2006 5:16 pm
by Mariam
I wrote in my validation rule the following..
C_Order.C_DOCTYPE_ID = 126

where 126 is corresponding to purchase orders in C_DocType table.

the reference for this column is 'Table', and the reference key is 'C_Order'.

PostPosted: Sun Jul 09, 2006 5:49 pm
by Mariam
Never Mind, Red1 :)
It worked!
the whole problem was that i forgot to check the updateable check-box in the my column. :oops:
thanks a lot.. really