I have a table with two fields: category and color.
The color field stores a user selected number according to a color, e.g. 39423, 52479, 16763904, etc.
I wish to create a form/report as a legend to a graph. The legend will display the category text and a control next to it showing the respective color - i.e. change the background color to the value of the color field corresponding to the category.
Since users can update categories and colors, I cannot make a fixed form, it must be dynamic, i.e. a continuous form.
Any suggestions will be appreciated.