Does that mean that you have selected the "include only related values..." option in Manage | Value Lists?
Do you need that option?
Thanks for your reply.
That is correct. I do need the "include only related values..." option and it is checked.
In cases where there are no related records, do you want this field to appear empty?
A conditional format could be used to make the field appear empty by either setting the text color to the same as the background or by setting the font size to 100+ when the value list is empty.
IsEmpty ( ValueListItems ( Get ( FileName ) ; "YourvalueListnameinQuotesHere ) )
would work for that.
You may also be able to use a simpler test that tests whatever field value is producing a "no related records" condition and thus an empty value list.
In the pop-up menu I'm displaying the list of related records and the option to add a new record if the needed record isn't present in the list. When there are no related recrods, I still need to display the option to add a new record.
There is no way to do that that I know of.
As an alternative approach, you could replace the "add a new record" option in the value list with a button for performing a script to do that nearby.
And forget my suggestion for a conditional format. That trick would work for a checkbox group or radio button set, but not a drop down list or pop up menu.
I appreciate your help on this. It looks like I'll have to go the Add New button route.