Executing Active Link 1 - Your executing active link should clear the external qual field. Then call a guide. There should be 5 active links in the guide. 1 for each field. with a qual of 'Field_x' != $NULL$
Set field = External Qual Field Value = ($External Qual Field$ + $Field_x$) + " AND " Executing Active Link 2 - This AL needs to clean up the external qual field and remove the last " AND " Run if = 'Extneral Qual Field' LIKE "% AND " Set field = External Qual Field Value = LEFT($External Qual Field$, COUNT($External Qual Field$)-5) Executing Active Link 3 - This AL just needs a change field to refresh your table. Jason ________________________________ From: lakhes <[email protected]> To: [email protected] Sent: Tuesday, March 3, 2009 7:55:19 PM Subject: How to do this? ** I have 5 parameter fields I need to build a external qualification using these 5 parameter fields First I need to check if they are null or value in there then then i need to build a external qualification of the table using all the one which has non null values. For ex: parameter fields are serial number, ci name, company name, manufacture name and product category if any of them have value I need to search asset table with external qualification Any suggestions ?__Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
