Hello!
its been a while.
i was told to add an drop down list to my company picture board for a new
set of divisions
called practice group.
easy enuff.
i want to be able, not to add the info in on an add or update.
But i couldnt figure out how to make it a None required field.
Although it is in access.
But now when i go to display my info.
I tried to only show fields for this Practice Group that where valid.
I had created a enrty called _none that i tried to hide or filter out & i
cant figure out how to?
_none is PracticeGroupID 18
have gone dumb do to not reading BF in a month or two.
<CFIF set_Emp.PracticeGroupID IS NOT "">
<CFSET set_PracticeGroupID = set_Emp.PracticeGroupID>
<CFQUERY NAME="Practice_Type" DATASOURCE="DB_phone">
SELECT PracticeGroup
FROM tbl_Practice
WHERE PracticeGroupID = #set_PracticeGroupID#
And PrcticeGroupID <> 18
</CFQUERY>
<CFELSE>
<CFSET set_PracticeGroupID = "">
</CFIF>
thank you
-paul
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
