New Record instead of Edit

January 10, 200323 yr

Newbies

We have a database (SpEvents.fp5) hosted on an FMserver. We then have a filemaker web server on another server (both OSX... FMP 5.5 unlimited on web). We developed a series of web pages using Claris Hompage's Filemaker Connection Assistant (we have done this a million times). Most of the pages and dbfs we host are "read-only", but in the past (when this server ran 4.0) I did make a solution just like the one I am working on now that allowed a user to EDIT data in a related (on the real server) database. So, the web database (Sp_EventsWWW.fp5) has one key field in it to relate back to SPEvents. Then on the WWW layout, all other fields are related fields.

The solution works fine for searching and browsing; however, when we try to EDIT a record, the process makes a completely new record in the related (hosted) database. There are no error messages generated (it look like, from the web end, like the task was successful)

I know that in v 5.x, there were some changes made that would effect this. I have seen similar postings here that talk about adding a ".0) to the end of the field name when pointing at a portal row. This, though, does not seem to work for me.

Why can't I seem to be able to do a simple "Edit" record the way I could in 4.x?

Any help would be greatly appreciated...

I have included some of the relevant code below.

Dean

*****************

<HTML>

<HEAD>

<TITLE>speventsWWW - Record Detail</TITLE>

</HEAD>

<TR>

</TD>

<TD>

<P><TEXTAREA NAME="Sp_Events::actual_menu" ROWS=7 COLS=30 WRAP=virtual>[FMP-Field: Sp_Events::actual_menu]</TEXTAREA></P>

</TD>

</TR>

</TABLE>

</P>

</BODY>

</HTML>

January 10, 200323 yr

Try this:

<P><TEXTAREA NAME="Sp_Events::actual_menu.1" ROWS=7 COLS=30 WRAP=virtual>[FMP-Field: Sp_Events::actual_menu]</TEXTAREA></P>

Placing a ".0" creates a new Portal row; i.e. record in the related file. Using ".1" should refer to the first related record (I guess that only one should exist).

All the best.

Garry