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,
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?