At 01:44 AM 31-10-01 +0000, you wrote:

>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?

Marco,
Basically, what you want is for MasterParamLinks replace the work that MasterLinks would do in determining the WHERE clause for the detail set. Looking at it as you have it now, I can't see how a _value_ could be determined for the WHERE clause parameter... Try changing MasterParamLinks to

ORDERS.CUSTNO=CUSTOMER.CUSTNO

regards,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________