Assign Colors to each Program column automatically

[SK28]

Hi,

I have a table which has distinct Program information

Program 

Aa

BB

Cc

Dd

Ee

and we need to only use color from a Single table

Color

Blue

Green 

Red

Yellow

Orange

......

....

..

etc

we have only 60 colors available.

Based on distinct program we have, can we automatically assign each individual color from the table? 

these programs might vary time to time

&

there is no association between two tables? is that possible 

Please help, appreciate your responses

Required output

Program.    Color code

Aa             Blue 

BB           Green

Cc            red

Dd           yellow

Ee           orange

& so on

[Anil_Babu_Samineni]

Not sure, why you want to make complex. If that is indeed I would rather prefer with 2 options.

1) With default color themes

Color(FieldIndex('Program',Program))

2) You can use themes

[SK28]

The problem here is @Anil_Babu_Samineni we are supposed to use Only Organization approved colors, We have even got the solution Using resident and Inline, QLik association, Im searching for Alternate or more simpler solution

Programs: 
Load Distinct Autonumber(Program) as ID

Colors:
load * inline [
ID, Color
1, #FFFFF
2,#FFEFT
.

.

.

 So On
];