I'd be extremely grateful if you could help me with one further question:
My organizations table has two fields. Name and Acronym. e.g Quickbase and QB.
Thanks to your instructions, I am able to display the related organization name and acronyms in my master Individuals table. The thing is, not all of my organizations use acronyms.
Is there a way to write the list formula so that: it will first look to display [Acronym 1], but if the field is empty, it will instead display [Organization Name 1]?
(And also, is there a good guide to understanding Quickbase formula you could recommend?)!
