filtering a drop down list from another field 1

[smartglass]

Hi:
I have a large number of stock items in a requisition system. These can be grouped by department.
When placing a requisition I would like a user to be able to select a department (not always his own) and the drop down list of stocks available would then be filtered as a result of the department selected.
Thus if on a form a user selects field DEPT = "CLEANING", then drop down list for field STOCKS will be only those for the cleaning department.
Thanks in anticipation!

 

[TonyMcGuire]

You can open a tcursor on an external table, set a range on it and use that table as the data source for the list.

I'm guessing you might place this on the changevalue method of DEPT, so it fires when a different dept is selected.

if not tc.open(":mylias:mydtasource.db")    then
  errorshow()
  return
endif
   tc.switchIndex("dpt") ;switch to the index on department
   tc.setrange(self.value,self.value); limit view to current department
   delayScreenUpdates(Yes)
   mylist'List.Count=0 ; initialize list
   scan tc:
      mylist'List.Selection=mylist'List.Count+1
      mylist'List.value=tc."stocks"
   endscan
   tc.close()
   delayScreenUpdates(No)

or if you have a table with only the list items already uniquely set aside, you can simply

(open())

DoDefault
self.DataSource = "[:myalias:mydtasource.LastName]"

Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.