Is it possible to Update related field?

[SoCalMacDude]

Lasso 3.6.6 and MacOS9 w/ FMP6.

Can you update related fields using the Update action?

Example:

<INPUT TYPE=hidden NAME="-Database" VALUE="Orders.fp5">

<INPUT TYPE=hidden NAME="-Layout" VALUE=Test>

<INPUT TYPE=hidden NAME="-RecordID" VALUE="[FMP-FIELD: 'recidnum']">

<INPUT TYPE=hidden NAME=Status VALUE=Closed>

<INPUT TYPE=hidden NAME="-UpdateResponse" VALUE="CheckOut.html">

<INPUT TYPE=hidden NAME="-Response" VALUE="CheckOut.html">

<INPUT TYPE=text NAME="Account Number" VALUE="">

<INPUT TYPE=text NAME="Customers::Email" VALUE="[FMP-FIELD: 'Customers::Email']" >

<INPUT TYPE=submit NAME="-Update" VALUE="Place Order">

This shows values from both databases, but renders an error -10005, which doesn't even show up in the documentation, when I submit.

When I remove the related field, it works.

Thanks,

Ken

[Anatoli]

I do not know about 3.6.6. Couldn't you use Inline and not displaying field names. That is security risk.

Maybe portal?

[SoCalMacDude]

I have been using inlines throughout the rest of the site, but for some reason it doesn't work on these couple (most important) pages. Want to check my code?

<FORM ACTION="action.lasso" METHOD=POST>

<P><INPUT TYPE=hidden NAME="-Database" VALUE="Orders.fp5">

<INPUT TYPE=hidden NAME="-Layout" VALUE=CGIInv>

<INPUT TYPE=hidden NAME="Order ID" VALUE="[Cookie: 'FlandersOrderID']" size=30>

<INPUT TYPE=hidden NAME="Customer Number" VALUE="[Cookie: 'FlandersID']" size=30>

<INPUT TYPE=hidden NAME="-Operator" VALUE=eq>

<INPUT TYPE=hidden NAME="-Response" VALUE="CheckOut.html">

<FONT COLOR="#FFFF00"><B>Next

Step:</B></FONT><INPUT TYPE=submit NAME="-Search" VALUE="Continue to Check Out">

</FORM>

Translates to this for an inline:

FORM ACTION="CheckOut.lasso" METHOD=POST>

<P><FONT COLOR="#FFFF00"><B>Next

Step:</B></FONT>

<INPUT TYPE=submit NAME=submit VALUE="Continue to Check Out">

</FORM>

CheckOut.lasso looks like this:

[inline:

database='Orders.fp5',

layout='CGIInv',

'Order ID'=(Cookie: 'FlandersOrderID'),

'Customer Number'=(Cookie: 'FlandersID'),

-Operator=eq

search]

[include: 'CheckOut.html']

[Error_CurrentError]

[/inline]

Can you see why it would not work? It brings up the CheckUp.html page, but the fields are not populated. Did I miss something in my inline?

[SoCalMacDude]

Anyone see the problem?

I am just trying to search on 2 fields, both of which are saved as cookies. The LDML version works fine, but is not very secure and I would like to use an inline instead.

Am I missing something when I translated it to an inline? Did I call the cookie wrong?

Help!!