OK, firstly I feel so dumb for needing to ask this ... but here goes ....
I have 1 table - one field inside that table is dynamic depending on other fields in the table, but thats updated easily *one point to me*
The dynamic field can be set to one of nine indicators (R1, R2, R3, P1, P2, P3...