autoNextRecord when the defined primarykey also a masterlink

--===============1179859918==
Content-Type: multipart/alternative; boundary=00151747932a3e9865049d4232ca

--00151747932a3e9865049d4232ca
Content-Type: text/plain; charset=ISO-8859-1

I hase 2 db tables -  purchaseOrder and po_item which both have a column
named "id" which is also the primary key in each.


The datasource in my gfd looks like this:

 <datasource name="dts_purchaseOrder" connection="test"
table="purchaseOrder" master="dts_opportunity" masterlink="id"
detaillink="uid_opportunity" />
 <datasource name="dts_po_item" connection="test" table="po_item"
master="dts_purchaseOrder" masterlink="id" detaillink="uid_po" />

i.e I've used the "id" column from dts_purchaseOrder as masterlink for
"uid_po" column from the DB table "po_item".

Now, my autoNextRecord="Y" stops working when I move out of the last block
of "purchaseOrder". The moment I remove the master/detail relationship, the
autonextrecord starts working. Can I work around it somehow? I want to be
able to create new records for the table "purchaseOrder" but also keep the
primarykey as id and also the masterlink on it.

Thanks in advance,
Kishan

--00151747932a3e9865049d4232ca
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>I hase 2 db tables - =A0purchaseOrder and po_item which both have a co=
lumn named &quot;id&quot; which is also the primary key in each.</div><meta=
 http-equiv=3D"content-type" content=3D"text/html; charset=3Dutf-8"><div><b=
r></div>
<div><div><br></div></div><div>The datasource in my gfd looks like this:</d=
iv><div><br></div><div><div><div>=A0&lt;datasource name=3D&quot;dts_purchas=
eOrder&quot; connection=3D&quot;test&quot; table=3D&quot;purchaseOrder&quot=
; master=3D&quot;dts_opportunity&quot; masterlink=3D&quot;id&quot; detailli=
nk=3D&quot;uid_opportunity&quot; /&gt;</div>
<div>=A0&lt;datasource name=3D&quot;dts_po_item&quot; connection=3D&quot;te=
st&quot; table=3D&quot;po_item&quot; master=3D&quot;dts_purchaseOrder&quot;=
 masterlink=3D&quot;id&quot; detaillink=3D&quot;uid_po&quot; /&gt;</div></d=
iv></div><div>
<br></div>i.e I&#39;ve used the &quot;id&quot; column from dts_purchaseOrde=
r as masterlink for &quot;uid_po&quot; column from the DB table &quot;po_it=
em&quot;.<div><br></div><div>Now, my autoNextRecord=3D&quot;Y&quot; stops w=
orking when I move out of the last block of &quot;purchaseOrder&quot;. The =
moment I remove the master/detail relationship, the autonextrecord starts w=
orking. Can=A0I work around it somehow? I want to be able to create new rec=
ords for the table &quot;purchaseOrder&quot; but also keep the primarykey a=
s id and also the masterlink on it.<div>
<br></div><div>Thanks in advance,</div><div>Kishan</div></div>

--00151747932a3e9865049d4232ca--


--===============1179859918==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
gnue mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/gnue

--===============1179859918==--