NDROCKS
Newbie
Karma: 1
Posts: 15
|
 |
« Reply #1 on: March 02, 2011, 11:27:27 am » |
|
The List Where Clause limits the values returned by the lookup based on the entered criteria.
The Validation Where Clause validates any entries made to the field whether they are selected or manually entered.
For example, I have two objects, say OFFICETICKETS and SERVICES. OFFICETICKETS object stores the service tickets raised for some services by employees of a company. SERVICES object stores different service providers, like HR, Finance, Infrastructure, IT, etc, and different operations of the service providers.
SERVICEPROVIDER AND OPERATION are two attributes in both the tables. The requirement is now, say, when you are creating a new service ticket, you need to select the service provider from a drop down list. When you select the service provider, the list of operations corresponding to that service provider should become available to you so that you select the operation you want to be fulfilled.
You have to create a table domain, say, SHOWOPERATION, with Object as SERVICES and in the list where clause you write, serviceprovider = :serviceprovider and in the list where clause you write 'operation in (select operation from services where serviceprovider=:serviceprovider)
Regards,
ND
|
