I just ran into a problem where running a Query By Formula bug in Client/Server that has apparently been around for a long time:
Client/Server Two related tables and automatic many-to-one is turned on 1. Select a record in the One table 2. Run a standard query to get the related records in the Many table 3. Run Query Selection By Formula on the Many table where the formula uses nothing from the One table at all The current record and entire selection of the One table is lost. You don’t even need step 2. Just run Query By Formula on the Many table. Even though the formula has nothing in it that touches the One table, the One table’s selection is cleared. It works fine in standalone. I discovered this in v16 R2 but it’s also a problem in v13.5. Has anyone else seen this problem? ------------------------------------------------ Richard Wright DataDomain [email protected] ------------------------------------------------ ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
