Liz

I am having the same problem. But I have used IWP. The 3 dropdown list that I have referenced to custom value list all lose their information when you edit one of them. I have one other dropdown list, it uses information from another field and it is fine. Can anyone help?

I'll give it a try. Thanks, Liz

Thanks for the feedback. I'll look into both.

The Help menu and manual are a little deceiving on the error codes. "Status(Current Error) function" is great when that is how it displays the error, but when you are accessing your DB from the web it isn't worded that way. This causes a FM newbie like myself to be alittle uncertain, but I appreciate both of your help. My problem now is how to fix this? I let filemaker web companion make the pages. Which is why "field is missing" didn't make too much sense. Maybe this is another way that the Web Companion makes publishing your database "easy"

I am relatively new to filemaker and a stranger to web developing. I have created new databases and scripts, run into a few problems, but with the help of the forums, have gotten my databases to do everything that they need to. Then I tried to post them on our extranet. First of all the product manual didn't really help me past enabling the web companion. Then most of my buttons do not work and there are some layout changes that I would like to make, that I can't. So I search the help menus and the forums and have gotten the impression that I either need to create custom web pages or get Filemaker Developer, in a nutshell, I need something else beside Filemaker Pro Unlimited to post the database and have it be user friendly. So now I find my self a little dissappointed in the program that cannot even transfer the buttons that I have made from the database to the web. I guess that my question is, am I incorrect in my assumption that I should stop trying to search through Filemaker Pro Unlimited Web Companion information and just start learning to make custom web pages?

I figured it out. It appears that you have to set passwords, even passwords that give full access. It was a pain that it did not say this when it was talking about passwords and security in the User's Guide. Thanks

I have just posted a couple databases to our intranet using the web companion. Everything seems to work fine EXCEPT when you try to change any of the Data you get an error message, "Data Entry Error - Your attempt to save current record failed because of the following - Unknown error number 102" As it is posted right now there are no passwords for either of the database,everyone can change everything. I have not changed the web layout, in fact after I enabled the sharing, I have not changed any of the "web" components from what the web companion set up originally. Can anyone help?

I am having the same problem as above, but I can't find any information on this at all in the help menu. Can some help atleast point me in a direction to go for more information on this. Thanks Liz

I am having a similar problem with the import/export process. I want to have my script export the selected records into another FM file, but when I set up the script and try it out, it replaces the 2nd file with a new file each time. Is there a way to have them added to the 2nd Dbase?

I am working with a product database where we have items that are discontinued. we need to keep them in the system for future reference, however they are in the way. I have created a field "productstatus" where the items can be marked, available, coming soon or discontinued. I would like to possibly set up a script where we find on the manufacturer of the product and the discontinued items are automatically removed from the find results. I'm not sure that this is possible. Does anyone have any suggestions?

ok, I think that I got it fixed. I re-wrote the script so that my If[] were in the main script instead of the sub-scripts. It seems that was where the conflicts were occuring. Thanks for all of your help

I do notice that in the instances where they are not sorted correctly, they are sorted in alphabetical order, so something is telling it to do that. If it matters

Ok, I went through each of the subscripts and tested them individually and they worked fine. It seems to be something that happens when they are all put together. In the main script I have - Perform Script[subscripts,"Inwalls"] Perform Script[subscripts,"Channel Vision"], on and on 16 more times. I checked and made sure that "Perform sub-scripts" was checked on each. Could there be a problem with the if statements contradicting themselves? Do I need to have something in the subscript saying that once the if condition has been met, the script needs to stop? I have tried to use the manual and the help menu for help with these scripts, but I have to say that they are not very helpful, so I really appreciate your help

I have each one as a seperate script and then have a main script that calls the subscripts, that is where the problem is occuring. I was not sure if there is a limited number of subscripts that can be called so maybe it gets half way through and quits?

I have a product database that has about 15 different manufacturers. I need to have each sorted in a different way depending on the manufacturer. So I have created an If script to sort each different (ex: If manufacturer="Jetson's sprockets" and then sort)I get each product line sorted the way that it should, create the script, then test it. Everything is good, BUT when I go back later and try to do this the script either won't work at all, or it doesn't sort the items in the correct sorting order. I have done this for each of the 15 or so manufacturers, but it only messes up on some of them. Is there something that I am doing wrong?