2 Replies Latest reply on Dec 8, 2016 10:44 PM by Snoopy7

    Related product record from portal will lead sometimes to wrong related product

    Snoopy7

      Product and version (FileMaker Pro Advanced 14.0.5, Server Admin Console-Version: 13.0v5 x64 (11-06-2014))

      OS and version : Client: Microsoft Windows 7 Enterprise, Version 6.1.7601 Service Pack 1 Build 7601, x64-based PC

      Browser and version (for WebDirect only)

      Hardware (Server: on VM ware Windows, Client: Prozessor     Intel(R) Core(TM) i5-2520M CPU @ 2.50GHz,

      Description:

      Relation Company -> Products  does not work properly in some cases.

      Only some (new) additional entered product record in portal will lead to wrong related product with a different ID (key).

      If product with ID 99 is already selected in product table then the relation out of Company portal works and not jumping to Product ID 104 occurs.

      How to replicate

      Seems related to newly entered records only, but not always. Or to ID 99 only leading to same wrong e.g. ID 104 (=latest entry). It seems ID 99 is related to latest ID #.

      Workaround (if any)

      In Products search ID or product name.

       

      key ID defined as:   _kp_IDProduct, Type: number,    Indexed, Auto-enter Serial, Can't Modify Auto

       

      Is Key ID not clearly defind that such wrong relation can happen?