Perhaps you have more than one related record in Abbreviations and the first such related record has an empty Abbreviations field.
What happens if you place the Abbreviations::Abbreviations field inside a portal to Abbreviations?
A portal will allow you to see all related records instead of just data from the first related record.
My portal has no related records.
layout in Descriptions table
Portal to Abbreviations table containing the fields Brand Name, Abbreviation
Do it the opposite way and it shows the proper link
Are abbreviations and Descriptions defined as tables in the same file? Are your two layouts in the same file?
If they are, please post a screen shot of Manage | Database | Relationships. You can use the "upload an Image" controls located below "Post A Answer" to include that image in your next post.
Go back to your descriptions layout and check the portal while changing to different records.
You can show all records and then use the book control to click from record to record.
My guess is that you had either an empty found set or that the current record did not have a value in brand name that matched any records in Abbreviations.
Figured it out - I had defined my fields in one of the tables as number fields. That'll do it.
I'm puzzled as to why your tables are related by brand. Shoud it not be a PK to FK relationship? PK being an auto entered serial and FK in the child table being a text or number file? No auto enter in the child table.
They're related by brand because I wanted to link to the abbreviation of the brand to use in a concantenated descritption using a calculation field. It's not a typical parent-child relationship.