Running Servoy R2 1.2 on Mac G4 Powerbook 10.2.8 with Firebird db.
Have a Form with tab panels. One tab has list of all (or foundset of) contacts. Selecting a contact from the list sets Global variable g_Current_Contact_ID and the Main screen (above the Tabs) shows the current contact based on relationship between Global and ContactID.
Problem is that after editing/adding Notes/Address etc in the Main screen and other Tabs the information is not saved.
Searching archives I found references to ‘autocommit’ but can’t find anywhere to set this.
Tried adding a SaveData method on ‘focus lost’ from fields but system just hangs up and I have to force quit.
Can someone point me in right direction on how to get relationship working both ways (sounds like real life…) - have a feeling that I’m trying to design it the Filemaker way and there’s an easier way.
Tried to post Solution Tuesday but hasn’t appeared. However problem was resolved by changing relationship link from text to integer field. Jan is looking the Solution to see if there was a real problem.
The problem was that left and right key weren’t the same type (integer-string).
In the next release we’ve put in a warning for the developer if a mismatch occurs during creation of relation.