Validation Rules

To err is to be human, to help each other is joy. Tell your Compiere needs in your own words. Let's figure out together.

Moderator: azaharizaman

Validation Rules

Postby Mariam » Thu Jul 06, 2006 8:44 pm

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,
Mariam
I am a Maker.. Not a Taker.
Life Makers (TM)
Mariam
 
Posts: 10
Joined: Sun Apr 30, 2006 3:07 pm
Location: Egypt

Postby red1 » Fri Jul 07, 2006 7:01 am

What did u setup in your validation rule? There are ready samples in GardenWorld, so u just have to refer to them.
red1
Site Admin
 
Posts: 2759
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Postby Mariam » Sun Jul 09, 2006 4:10 pm

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?
I am a Maker.. Not a Taker.
Life Makers (TM)
Mariam
 
Posts: 10
Joined: Sun Apr 30, 2006 3:07 pm
Location: Egypt

Postby Mariam » Sun Jul 09, 2006 5:16 pm

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'.
I am a Maker.. Not a Taker.
Life Makers (TM)
Mariam
 
Posts: 10
Joined: Sun Apr 30, 2006 3:07 pm
Location: Egypt

Postby Mariam » Sun Jul 09, 2006 5:49 pm

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
I am a Maker.. Not a Taker.
Life Makers (TM)
Mariam
 
Posts: 10
Joined: Sun Apr 30, 2006 3:07 pm
Location: Egypt


Return to Ask RED1 personally

Who is online

Users browsing this forum: No registered users and 2 guests

cron