Hi There,

just thank you all for the input, I have done the changes suggested and it worked perfect

Thank you All

Abdel

Hi Erland,

thank you for the query, it did work good for me and the only issue I need to fix now is

ID ...

Thank you jeff

Hi there,

thank you for the reply and didnt mean the kind of as I dont know what I want 🙂

thats what I am capturing at the moment

Maincase

ID ...

thats correct, I need kind of when 1 level is set to capture a date and if that level changes I need to record say when that level has changed...

idintno410 0 no

victimliaisonofficernvarcharno510 yes

recordidintno410 0 yes

victimsurnamenvarcharno450 ...

Hi there,

thank you for the answer and please find the create a table

Create TABLE Levels(

ID INT,

...