using a field vaule in add/edit page as where clause

This topic is locked

using a field vaule in add/edit page as where clause	12/29/2007 10:36:17 AM
ASPRunnerPro General questions
C carlo author Hi i need to use a field value in add/edit page as where clause into a second field i could not use lookup table becouse this second field it is already depending from another field. my situation is FIELD1 FIELD2 (it is tha master for FIELD3) FIELD3 (it is depending from FIELD2 ; her i need to have also a filter with where clause and FIELD1) any idea ? thanks in advance. Carlo p.s. HAPPY NEW YEAR TO EVERY BODY

Mark as Solved Mark as not solved

3 replies


J	JOHNF777 12/31/2007
	You can do these using the "Lookup field" function, with Category control. You can also use a "View" (like in SQL View) to do the "where". I find this better than using the "where" box in Lookup wizard.


C	carlo author 1/8/2008
	You can do these using the "Lookup field" function, with Category control. You can also use a "View" (like in SQL View) to do the "where". I find this better than using the "where" box in Lookup wizard. i have tried but with 3 value is not possible... i have FIELD1 = a lookup field FIELD2 = a lookup field FIELD3 = a lookup field with category on FIELD2 <- here i need to add WHERE clause for FIELD1 any suggestion ? thanks carlo


J	Jane 1/11/2008
	Carlo, you can add your where clause in the WHERE box on the "Edit as" settings dialog on the Visual Editor tab.

3 replies

Mark as Solved Reply