Trouble linking two databases. Please help.

[Urizen]

Hello everyone,

I am having some trouble. This is the situation. I have two databases, one called Profiles(holds the Last Name of a person and some other info) and the other called Records. I want to link these through the web so that when I create a new record in the Profiles database and enter all the data in it, I want the text field that holds the Last Name in the Profiles database to transfer into another text field in the Records database. Essentially, the Records database is almost like a sub-database to the names in the Profiles database. I am ale to do this using buttons, and Input, and Form, but I wondered how I would do it simply using A HREF?

The following is the code I used for a page with a button to create a new record in the Records database, after the data in the Profiles had been entered for that person:

"

<FORM ACTION="FMPro" METHOD="post">

<P><INPUT TYPE="hidden" NAME="-db" VALUE="profile.FP3"></P>

<P><INPUT TYPE="hidden" NAME="-lay" VALUE="Layout #1"></P>

<P><INPUT TYPE="hidden" NAME="-format" VALUE="newrecord.htm"></P>

<P><INPUT TYPE="hidden" NAME="-RecID" VALUE="[FMP-currentrecid]"></P>

<P><INPUT TYPE="submit" NAME="-findall" VALUE="Create New

[Vaughan]

FMPro?-db=profile.FP3&-lay=layout%20#1&-format=newrecord.htm&-RecID=[FMP-CurrentRecID]&-Findall

A couple of things here:

1) check the html code for the # character in the layout name;

2) this form specifies a particular record in the database CurrentRecID then uses the action tag -Findall to create a new record. Why? I'd use -New. Perhaps this is just a typo.