IWP - <File Missing>

[Royce]

Greetings FMers... Running on FM10 FMSA; FM files work fine in the relationship... but on browsers, on all fields....

IWP on for both files (presentation and data dbs) is turned on ... I gotta be missing something simple.... if you have a moment, any thoughts would be apprecaited...

Royce

[innodat]

Did you specify an different user-account for web-access? If so, it's possible that you are not allowing the user to access the fields you placed on the IPW layout.

Check your Privilege Sets in the Accounts Set-up, specifically the Record Privileges.

[Royce]

rheinport - thanks so much for the response. I originally cloned the file to use as a front for the database (therefore it is an exact replica - the basic presentation vs data setup) while keeping the related database in the background, so their settings are (almost) identical from a privilege perspective... AND I made them identical to rule that out, which I did...I can get to the data file DIRECTLY if I go to it and it works fine... it must be in my relationship...my wife always told me I was bad with relationships.... I think I need more sleep...sleep...sleep... WAIT! Conference call in 15 minutes.... thanks again... I do appreciate your input...Royce

[Royce]

New Info - I tried to make a new record from my presentation site and I got the following error message -

"The page at http://172.32.0.18 says:Database Not Open:

Unable to process your request because the database "" is not open."

So it's not even seeing the data - databse... hmmm... that's strange... they are both being hosted IWP on FMSA... and I can get to both of them separately....

[innodat]

Ah, did you check the name of your file path for the External Data Source? The link between the two files, make sure you have the full server path and not just "File.fp7". It should look something like this:

fmnet:/full.server.address/File.fp7

Maybe I'm pointing out the obvious...

[Royce]

It's always good to point out the obvious - at least to me! Sometimes I'm looking too deep and it usually is the simplest thing.... I did check that a couple days ago and switched it from relative to specific... actually, I wonder if that is when I started having a problem...hmmmmmm... it's currently set locally to

fmnet:/172.32.0.18/wwwgabrielwhitepianocom.fp7

Should work okay...

I just noticed on the status bar (on the IWP, not the FM db) that when I open the browser to the home page it shows one record (that's all I need in the presentation db) BUT when I click on the web button to go to the order page (a different layout), when it get's there the Status says "0" records.... hmmm.... I am supposing that is because it is in edit mode waiting to submit... let me check.... nope that's not it.... why would there be one record showing (correctly) on the home page but not on the order page... maybe my layout reference on home is to the presentation db and the layout reference on the order page is to the Data db.... let me check... yep... so it shows the one record correctly on the Home page and shows no relationship, or "0" records on the Order page.... it's gotta be in the key that builds the relationship (I start a new record with each session so I can track where the user goes, what gets clicked, etc. whether they buy or not so I can build patterns and thus make changes for a better experience...). The key must not be getting into the right field for the relationship.... any other thoughts? Thanks for your help... your thoughts are both insightful and help me think deeper toward the solution...

Edited January 30, 2010 by Guest
Added to the post...

[Royce]

More still.... okay... I think I'm almost there... it was simple AND stupid (me that is)... I had a new record step at the beginning of the session AND when they hit the order button - that was moving me off the record I made WITHOUT then submitting (Committing Record) so it was related to NO record and thus showing no info.... COUPLED with (I hate it when there are two problems and you're only looking for one! arrrrrggggg...), coupled with the layout referring to the data db instead of the presentation db that had the fields already set to look at the data db....so it was referring back to itself (presentation) instead of to the data db... I am still not loading in the primary key properly though because I have it showing on the layout so I can see it to ensure proper relationship during testing - it is appearing on the FM dbs but not in my browser even though I have "submitted" automatically by Committing Record.....But now I gotta go do my Honey Do List so I'll come back later for (hopefully) a final solution! Thanks again...