Hi All,
I'm trying to create a simple base that allows me to track items in boxes. An item can only be in one box so a one-to-many relationship seems like the right thing here. I added the link field to my Items table and made sure that "Allow linking to multiple records" is off in the settings. This works when I'm adding items and putting them into boxes. However, when I open the Boxes view and add an existing item to a box, it does not get removed from the previous box. Instead it ends up being in multiple boxes at the same time, exactly as if it was a many-to-many relationship.
This looks like a bug to me. Is there any way to move an item without having to remove it manually from the old box?
Thanks for your help, P
