Combining Value Lists

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

Combining Value Lists

Postby rochard » Mon Aug 16, 2004 4:08 am

I have a table ActionItems that contains hundreds of records of actions that are specific to a certain customer and a related value list that shows the actions for the client whose record we are in at the time. The table contains three columns only; ClientID, ActionItemID and ActionItem.

What I would like to be able to do is have a series of global actions that are available for every client and have those appear in the same value list.

is this possible and if so, how do you do it?

TIA[/b]
Michael Rochard
rochard
 
Posts: 142
Joined: Thu Jan 29, 2004 12:11 am

Postby automazione » Mon Aug 16, 2004 9:53 am

Hi Rochard, I think your task is not difficoult to implement using function:

application.setValueListItems('my_en_types',dataset)

simply add the global actions to the resoult of a query on ActionItems and store it on your valuelist using setValueListItems()

hope this helps, ciao
Enrico Arata
Servoy Italia
automazione
 
Posts: 366
Joined: Thu Apr 24, 2003 11:37 am
Location: Torino, Italy


Return to Programming with Servoy

Who is online

Users browsing this forum: No registered users and 32 guests

cron