Tab based on a self-relation and new record creation[SOLVED]

Classic Servoy
1

Hello everybody,

I was developing an amazing application when I stumbled upon a rather annoying problem. I don’t know whether it is servoy, framework or application related. In any case, here’s the issue I have.

First of all, I’ve got a form ‘company_form’ using table ‘company’ which displays companies’ information. Then, a second form ‘company_form_details’ which again uses the same table but displays different fields. Now, I’ve created two programs, one named ‘CompanyDetails’ that uses the form ‘company_form_details’ and a program ‘Company’ which uses the form ‘company_form’ and has a related tab using the CompanyDetails program with a self-relation from Company to Company (inner, no create, no delete).
The fact is, when I try to create a new company from the browser button bar, the dc_new method actually creates two company records instead of just one, so that when I click on cancel (although the call to databaseManager.rollbakEditedRecords() get executed and calling databaseManager.getEditedRecords() returns nothing) the company_form’s foundset remains set on the second newly created record instead of repositioning on the previous displayed one.

Do you have a simple explaination why? Have you already encountered this kind of issue before? If so, do you have a solution ready to use?

2

Ok, after a very productive meeting with Sanneke here’s the solution (thanks Sanneke :D):

just create a self relation with no conditions so that servoy knows you just want to replicate the parent’s foundset. This way the problem has gone ;)

Hope this helps someone else.