Jump to content

Adding record doesn't perform lookups using CWP


Hope Ray
 Share

This topic is 5698 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 by Guest
Link to comment
Share on other sites

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!

Link to comment
Share on other sites

This topic is 5698 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.