Subject | Master detail Bug with MasterParamLinks? |
---|---|
Author | Marco Menardi |
Post date | 2001-10-31T01:44:46Z |
Ibo 4_2_F
I've changed the MasterLinks demo to test the MasterParamLinks instead
of the MasterLinks.
So I've changed the qrOrders.SQL this way:
SELECT *
FROM ORDERS
WHERE CUSTNO=:P_CUSTNO
And put on MasterParamLinks:
P_CUSTNO=CUSTOMER.CUSTNO
In browsing mode the detail works fine, but if I insert a new Order
row and insert OrderNo, the CustNo is not automatically assigned the
current Customer number! (with MasterLinks it did). So I can't post
the detail record without entering the CustNo by hand!
What's wrong?
Regards
Marco Menardi
I've changed the MasterLinks demo to test the MasterParamLinks instead
of the MasterLinks.
So I've changed the qrOrders.SQL this way:
SELECT *
FROM ORDERS
WHERE CUSTNO=:P_CUSTNO
And put on MasterParamLinks:
P_CUSTNO=CUSTOMER.CUSTNO
In browsing mode the detail works fine, but if I insert a new Order
row and insert OrderNo, the CustNo is not automatically assigned the
current Customer number! (with MasterLinks it did). So I can't post
the detail record without entering the CustNo by hand!
What's wrong?
Regards
Marco Menardi