On the formatting page I have a field that uses a lookup against another table in my access database to set the value of the field. Basically, it gives me a list of school names and sets the field to the equivalent school ID. I can see the field gets set correctly on the database, but neither the view or edit pages display the field. It's just blank. Also, if I try to have school ID as one of the fields on the list page, it messes up and just displays the first record only.
Can anyone help me with this. Thanks.
