AnsweredAssumed Answered

Re-Login and External Data Source Issue

Question asked by bbtops on Jan 10, 2012
Latest reply on Jan 30, 2012 by rkappel

Hi All,


Been delevoping for FM for about a year now and trying to branch out into IWP for our customers.


I'm trying to setup a separate IWP database file (let's call it #1) that accesses data from another .fp7 file (#2). I'm doing this to try and add a layer of security and keep things clean in our primary database, but yet pull information from database #2 into #1.


I want to give customers the ability to log into file #1 using a guest account, then after they enter their user credentials that matches a table in database #1, the re-login script is called, re-logging them into an account that matches the credentials in both files #1 and #2 so they can access table data in #2.


Here's where the problem lies. After they log into database #1 the external data-source (file #2) doesn't recognize the account, and will not permit records to be viewed in file #1 (expected response). BUT, Even after the re-login script is called, the records from file #2 are still not available and I get a <File Missing> error on associated tables from #2. I get the same problem when using FileMaker and not IWP. If the inital call for user credentials for database #2 is canceled, there's no way without closing and reopening the file to reinitialize the authentication with the external Data-Source.


Am I missing something here? Any workarounds to this or a way to re-initiate the connection to another .fp7 file after the Re-login step is called?


Been banging my head on this for a while now....


Much Thanks!