Status tracker box

[axm0035]

Hello,

I need an Account Status tracker box on my DB to let me know when a property
went into “Activated, Rescheduled, Transferred, Trained, Pending†status. I
need to know the different stages each property has gone thru and when.
Example, property 123456 went into “Pending†status on Monday 12, and then
went into “Rescheduled†on Tuesday 13, then “Trained†on Wednesday 14, and so
on. All this should be tracked on a separate box on the side telling me when
all this status changes occurred.

Hope some one can help me.

Thank you.

 

[Daryl S]

ASM0035 -

Not sure if you are asking for general direction, but you should add a new
table to track this, one with the propertyID field and either the Status
fields or StatusDate field as the key, depending on if you can have a
property attaining a status more than once.

You can then create a small subform to display these fields, and add the
subform to your main form - linked properly with the PropertyDI, this will
show the status and date of any changes for the property on the main form.

You would need to provide more details in your posting to get a more
detailed solution.

 

[axm0035 via AccessMonster.com]

Thank you very much. Thats exactly what i had in mind but i wasn't sure if
there's another way to do it.

ASM0035 -

Not sure if you are asking for general direction, but you should add a new
table to track this, one with the propertyID field and either the Status
fields or StatusDate field as the key, depending on if you can have a
property attaining a status more than once.

You can then create a small subform to display these fields, and add the
subform to your main form - linked properly with the PropertyDI, this will
show the status and date of any changes for the property on the main form.

You would need to provide more details in your posting to get a more
detailed solution.

Hello,

[quoted text clipped - 11 lines]

.