0

how do i delete a reference between rows

i have two tables that are linked

how do i delete a row reference without deleting the tathet object

12replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Sean
    • Sean
    • 3 yrs ago
    • Reported - view

    Click on the unlink button...

     

    Screen Shot 2019-05-23 at 9.56.51 PM

    Like
  • that button doesn't show on the iphone application.

    Like
  • and it doesn't show on the web application

    Like
    • Nick
    • Nick
    • 3 yrs ago
    • Reported - view

    On the iPhone tap the reference (relationship). then tap the Menu (top right, 3 dashes) and finaly tap Unlink

    Like
  • 01 I am on my table view

    01 the parent record

    02 I click on my parent record

     

    02 the parent record opened up to click on the reference "outbound"

    03 I click on the child record "Sarah"

    03 looking at the child record and clicking on the burger in the top right

    04 I click on the hamburger in the top right corner

    04 no option to unlink ?

    there is no option to "unlink"

     

    iphone 8+

    ios 12.3

     

    :-) 

    Like
    • Nick
    • Nick
    • 3 yrs ago
    • Reported - view

    IMG_0666

     

    Maybe your record is locked (writable if)? Or try to unlick from the other side.

    Like
  • Ah, I am linking to the same table,

     

    ie person <is-a-relative-of> person

    Like
  • I attached my sample test db, on the web I can "unlink" on the iPhone I can't Doh !

    Like
  • here is the People.ninox in base64 format. just do "pbpaste| base64 -d"

     

    VUVzREJBb0FDQUFBQURKRnVFNEFBQUFBQUFBQUFBQUFBQUFMQUJ3QVkyOXRiV1Z1ZEhNdVpHSlZWQWtBQTBDdTUxeEFydWRjZFhnTEFBRUU1d01BQUFUbkF3QUFVRXNIQ0FBQUFBQUFBQUFBQUFBQUFGQkxBd1FVQUFnQUNBQXlSYmhPQUFBQUFBQUFBQUIyQUFBQUN3QWNBR0poWTJ0MWNDNXFjMjl1VlZRSkFBTkFydWRjUXE3blhIVjRDd0FCQk9jREFBQUU1d01BQUt0V3lreFJzbElxdFN6TUtVck16czVLTTAwdnowOHpVTkpSU2trQ3k2UW5saVVibFpjWmxGWGtaNEpGOHhKelU0SGlBYW41QlRtcFFKR1N6TnpVNHBMRTNBSWxLME5UVXdzekMzTWpTek5MSXhNZHBkTGkxQ0tneXNpZ2NOOFFaMHVYQ0tQVXlIeXZTTmNNcFZvQVVFc0hDSnJBVUZodUFBQUFkZ0FBQUZCTEF3UVVBQWdBQ0FBeVJiaE9BQUFBQUFBQUFBQWhEUUFBQ2dBY0FHaHBjM1J2Y25rdVpHSlZWQWtBQTBDdTUxeEFydWRjZFhnTEFBRUU1d01BQUFUbkF3QUE1VlZOYitJd0VMM3ZyMWo1c3Bkb1JleDh3YTE4dElKdHQ0V2liU3RVVlNFeHhDVWtxWk5BcTRyL3Z1TTBBVVBZQmxyMXRKZklzV2VlMzV0TTNvelEzZURtWXRpcXQyOHh2UXQ3ZHgwUEthcXVXNFpscWpWTnJ4TUZ4WTVINXpaU1hsRk1uMUJEVmRDQzhwaUZBV3BnQlFYME9SbStSTFRyWnE4SkxHUFVlRVVuNGlFT1R4bjFYWEdxS2NpeG95UkxSRmNBQVFzRmVjeDFLZXhNYkQrbUNwcUk2QTNBMkk0cFJNY0paOEVVeVFCRGdJWU5UcDlTeHFtN0JnaTVTemxxMUFBcTVQTWI1aVlldlAzVUZaU21ETUpRYjlaK0RLNGpOdFBPTG4xMjJRU1FxUitPYmYrYTJ0eUI0SVNuZ09QWmNUZHc2Zk1hK0kzRFNacUVUc2c1ZFpJaTh1M2dJdlVUNXJPQXJoTTh5cVllUktrckJUVWxNWnhPdHBSY3BzazRUQU4zbnhxSUxZb0xCY25lMS9WRXJRd21kbXlYN3NvWEg0blJaU3NNSm13cTdwNkhJZ2dsOXRpbmFMVXV4dElibkErdEhoNEU0L0NhWHdnT1V0blU3RUxLYWVEUUFZVnFjSUdOb2pCS0l3SFMybEsxMkZMVkRUYWkzdEVneXA5enhnZHlmcGsxQnhlRFA4TnV1OTh5ejRtQUxFcHRsT21MWHBYSlp3MkdWZ0tPaVQ3YjRFNmJMQmozakt0ZXIyLyttaS8zTjhacXRici9ObnJ2cjFGVnM1YVhIMVdGYXRnRXlnNm5ka0xodWhOVi9HVVBHUnV4Umc4T0xIZWlIK2I3OWxKSTJYTVRJUHp6SklhZm1WU3B3YVJPYWpKRkxGSEV1eFR6NkMySzY3MFBVdFFxS1dyRUFtOUpJMWV1SXRnSGF0c0xhSnpLZEdQN0l4QkpJU2twZkl2ZVZsanNmVkNoVVVXUllJc1lza0lpSy93UmZ6L2xERHE4VWlyQmRjdVVwV3FTVkcxWGFoNjlKWFc5ZDd4VU1Jc1J1YzhsV3dkUzNaSGNQS0FkZEVLMGNyRWdNMGg5LzhCa1R1ZmhJcTlRVlViZE5DMDVBMWRsR0lhbDRsSy9OZy80R1V1Wm1iVE1oZFhDbnQ2SHdBU2JOYTA4MDdFMDFNa3hROTM0ajRkNit5dUdldWZ6US8zV0hmUi9tOGJ5c2VPY3RYWGFQMjZvZHo0LzFOdkhEL1dicU51ZGpZZVBVelpMbHlxWkhqZlVjN1F2RytyZzhIVU55ODZwUzg2cDd6aG5FUzA3NTJidmVPZUVMekpTQytkVXExeWl1R25IWDZCWjlhcE1Rd1UvMjVkNWdIV1drN01TZFhKenlqcTVzc3hHdmFadTJhOWVZYWJZTkUzZDJFZTVza3lsVENMekxjejBMMUJMQndnLzJuRWtLd01BQUNFTkFBQlFTd01FRkFBSUFBZ0FNa1c0VGdBQUFBQUFBQUFBTlFBQUFBMEFIQUJ6WlhSMGFXNW5jeTVxYzI5dVZWUUpBQU5BcnVkY1FLN25YSFY0Q3dBQkJPY0RBQUFFNXdNQUFLdFd5a3ZNVFZXeVVncEl6Uy9JU1ZYU1VjcE16czhEOGxNU1N4S1RFb3RCSXNuNU9mbEZRQ0ZsWTJOTHk1UVVwVm9BVUVzSENJNUNhRU15QUFBQU5RQUFBRkJMQXdRVUFBZ0FDQUF5UmJoT0FBQUFBQUFBQUFCY0JBQUFCd0FjQUdSaGRHRXVaR0pWVkFrQUEwQ3U1MXhBcnVkY2RYZ0xBQUVFNXdNQUFBVG5Bd0FBalpOTmM5b3dFSWJ2L0lyT1h0ck9lRHExQVp0d0k0R2toa2tKaEpSd1l2eXgyQUlqT2JJRmFUdis3MTJaWUQ2YWRyaDRKTzJyWi9kZHJiUDJiOGp3QmRxbVpjQUdaY1lFaDNiZEFJNnYrZVJuaW00SWJRcmx0TXlBeEIzOTBjRmJoa21vbzdZQmdaZm01VVY0SUFRdERJaFpHQ0tkTEx3a1F3TVdXbjBBK0Y2R3BNNXl5WGdFeDRBSm9lbEE0b3RpRXNNS0lHU0lFdHBmQ1NYa2VzckNQS2JkbDZZQlNqR1NRWC9WWGZMSGxLMGFkOE9FRGE4SkVpWEM5NUpIOUdSQTRsd3E0c1JlNXZJUVh5dndyb2FPeWtVZ3BNUWczeXQzZ1h1VjVDeGhIS3NMTWJJb0pwVlpHTkE5TWlOeGNlSmtxSEpmS0I2KzU0YTArK1pTUThwOTFVL29sWmdzOEVJOHQyL1NJekhjM2dpK1lKSE92UlphQkxubkp3aEYxWXpuY0R6Njd0amJaUys0NnpaeEJDZHRNOHVFS0pFSE9FYnFodFJzU0VXcVVnM3BuYmphbkxoeStjSFVmengwb2FyWnVyRG1hZXE2SzMreWpOaEtiYzI2SG90OXErMi95OWV6ZWx6OEcwM2ptSjZ6QXplNlp0enYydy85L3NnWnJMZnZEMFpSRkxVZlVxdzJtNmR2Zzlhdk1YZE5IRkN0SmVIOEhIYi93NXZ2UTI4K2VVbnlXWjlVVmlzWmxWUCtabFpSZStxWUZKa0hSRGFielpiZGNreXpZVG5rY1I0b0VzL0cwL3ZKelZYMzJjS1o2TTk2TVJIbjY0UGFjaHlucWRYcmY2azcrZ0c4RFVJNW9IV2RzbjZlMG1yWWw2YzA2OVpWeTdrazVjZnN3NjFrOUN4UTFQNEFVRXNIQ05hRDhQd0hBZ0FBWEFRQUFGQkxBUUllQXdvQUNBQUFBREpGdUU0QUFBQUFBQUFBQUFBQUFBQUxBQmdBQUFBQUFBQUFBQUNrZ1FBQUFBQmpiMjF0Wlc1MGN5NWtZbFZVQlFBRFFLN25YSFY0Q3dBQkJPY0RBQUFFNXdNQUFGQkxBUUllQXhRQUNBQUlBREpGdUU2YXdGQlliZ0FBQUhZQUFBQUxBQmdBQUFBQUFBRUFBQUNrZ1ZVQUFBQmlZV05yZFhBdWFuTnZibFZVQlFBRFFLN25YSFY0Q3dBQkJPY0RBQUFFNXdNQUFGQkxBUUllQXhRQUNBQUlBREpGdUU0LzJuRWtLd01BQUNFTkFBQUtBQmdBQUFBQUFBRUFBQUNrZ1JnQkFBQm9hWE4wYjNKNUxtUmlWVlFGQUFOQXJ1ZGNkWGdMQUFFRTV3TUFBQVRuQXdBQVVFc0JBaDRERkFBSUFBZ0FNa1c0VG81Q2FFTXlBQUFBTlFBQUFBMEFHQUFBQUFBQUFRQUFBS1NCbHdRQUFITmxkSFJwYm1kekxtcHpiMjVWVkFVQUEwQ3U1MXgxZUFzQUFRVG5Bd0FBQk9jREFBQlFTd0VDSGdNVUFBZ0FDQUF5UmJoTzFvUHcvQWNDQUFCY0JBQUFCd0FZQUFBQUFBQUJBQUFBcElFZ0JRQUFaR0YwWVM1a1lsVlVCUUFEUUs3blhIVjRDd0FCQk9jREFBQUU1d01BQUZCTEJRWUFBQUFBQlFBRkFKSUJBQUI0QndBQUFBQT0K

    Like
  • How do you unlink in code?

    Like
    • Sean
    • Sean
    • 2 yrs ago
    • Reported - view

    Set the table reference equal to 0. So if you wanted to unlink the current record in the many table you would use code like this...

     

    let curRec = this;

    curRec.(YourTableReference := 0)

     

    If you wanted to unlink all the records, you would use code like this...

     

    for i in select ManyTable do
    i.(YourTableReference := 0)
    end

    Like
  • Yup, thank you. I worked it out when the error wanted a return value.

    Like
Like Follow
  • 2 yrs agoLast active
  • 12Replies
  • 2608Views