AnsweredAssumed Answered

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

Question asked by Snoopy7 on Dec 8, 2016
Latest reply on Dec 8, 2016 by 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?

Outcomes