Did you use the Insert menu to insert the merge field?
Unless your layout is based on an occurrence of the table where __pkAssetID is defined, there should be a table occurrence name in front of the field name.
Yes, I used the Insert menu to insert the merge field.
The layout is based on the table where __pkAssetID is defined. So like I said, really not sure why it isn't displaying the value. Actually, playing around, if I put a merge field on the layout for any of the fields defined in that table, the same thing happens. The merge field doesn't update to display the field value.
I rebuilt the database from scratch and it works fine. I guess you should avoid bulk copying and pasting.
Bulk copy/pasting works, but you have to pay attention to certain key details--the underlying tables underlying each layout have to have fields of the same type and name and their table occurrence names should be identical.
Otherwise you have to "repoint" all field objects and portals, plus you have to re-insert your merge fields.