AnsweredAssumed Answered

List of value and table multi-values

Question asked by fc60 on Oct 26, 2013
Latest reply on Oct 28, 2013 by IT_User

Hello,

I have a table with some codes and descriptions ==> Id; code_group; code_item; des_item

 

Exemple:

 

IdGroupCodeDescription
01ROLEPROGProgrammer
02ROLEANAAnalyst
03ROLEPMProject Manager
04COMPGMGeneral Motors
05COMPBOSBosch
06COMPWALWalmart

 

 

To make a relationship between this table and an other table is not a problem, I use the ID, but I want to create a list of values for a combo box only with id and des_item for the group that I want use in the module (For exemple a combo box for the roles of a resource).

Many tanks for the help.

PS: I also accept other types of solution, but with other database I always used this system. I dont like have a table for each code_group.


Outcomes