Thank you, chaley!
Your response (and the part about other columns referencing #collection) got me thinking about why it wouldn't work for my library.
I had used a custom column with the lookup name #collection before, when I was manually sorting books into different virtual libraries. I had deleted it, so I thought I could re-use the lookup name.
It turns out that I had defined #collection as "hierarchical" elsewhere in the preferences and that hadn't been deleted. Once I removed that, everything worked as expected.
Thank you for your help!!
|