I have two tables - one named [main] the other named [KPI]
main:
ID = primary key
KPI = this is a name (green, red, amber)
KPI_ID = child
KPI_pic (currently just storing an image to make things work - not good use of a database)
KPI:
KPI_ID = primary key
main_ID = child
KPI_color = this is...