Keep creating new record in related table
I cannot understand where the problem lies. I have two tables, Member and Status, joined by a join table Status_Member. I want the status of each member to show in a pop-up list in the Member records. The problem is that every time I allocate a status to a member, a new record is created in the status table. The obvious solution seemed to be to remove "Allow creation of records etc" in the relation but if I do that, the pop-up stops working. And strange to say, if I conver the pop-up to a pull down, the status name ceases to be displayed and is replaced by the record number.