Adding record doesn't perform lookups using CWP

[Hope Ray]

I can tell everyone how many times I have read the CWP Filemaker guide and I'm still struggling. My problem seems simple but it's driving me looney. I have created an addrecord.xsl from the Site Assistant. It lets me add a record into my database but when I look in the database I noticed that several fields that have calculated lookups don't show their data. These lookups are from another database but I have created a relationship table. Is there some secret to make the database perform the lookup once the xsl passes the information to the field? Also Martin, I found an example you had post from a while back but it doesn't work for me. You have a input text on the stylesheet that is hidden with the name "Key" and the value=1. Of course the database you use has a key field with a value of 1 and then that is the "primary key" in the tables. I am actually entering in the "Primary key" field information and passes it to the database but it never performs the lookup. I have also checked the privledges to the database and guest have full privledge.

So does anyone have any idea how to make the Site Assistant add a record and that record information that is passed to the database perform the lookups?

Thanks in advance, any answer will save my sanity!

This is not a useless lookup just in case someone want to ask why am I doing a lookup. The primary key is a userid and I bring in the persons name along with other information and allow them to change it.

Edited April 30, 2006 by Guest

[Garry Claridge]

Could you possibly trigger a Script, whenever a record is added, which forces the Look-up?

Good Luck.

Garry

[Hope Ray]

I tried the script thing and it didn't work. I did fix it though. It seems the lookup database didn't have the correct privledges for xsl, it only had read. I changed it to full privledges and everything worked great!

[Garry Claridge]

Good feedback :

Thank you.

Garry