AnsweredAssumed Answered

Keep creating new record in related table

Question asked by kevork on Apr 12, 2014
Latest reply on Apr 18, 2014 by kevork


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.