Dropdown in a related TO does not refresh

[Tom Kennedy]

I have an Employee table occurrence (TO) which has a related Manager TO through a field called ManagerID. I have created field called StatusID in the Manager table. This StatusID field is related to a table called Status.

On the Employee layout (with the Employee table as its source), I have created a dropdown for the ManagerID field which works fine and refreshes the ManagerName edit box which is located right beside it. I have also created a dropdown for the StatusID field and I want to display the StatusDescription edit box right beside it. The StatusID field works fine but the StatusDescription field does not refresh when a StatusID is chosen from the dropdown. The StatusDescription will refresh if I click on the StatusDescription edit box.

Any Ideas?

[Dr. Evil]

you could attach a script to the field with your drop down...

Set field behavior so you can not enter in browse mode and turn field into a button with a script that look kinda like this....

>commit record

>go to field

so your script will refresh for you.

I would double check your relationships and TOG (Table Occurance Groups)/relationships and make sure they are good, i don't know why list would not update on it's own.