mattc Posted October 9, 2007 Share Posted October 9, 2007 Hello, I have a call log db solution that allows our customers to log problems by email. My question is to do with Server 9 & SQL integration - so I hope i'm in the correct area We use two SQL tables for 'mail_in' and 'mail_out'. I have added the SQL 'mail_in' table to my FM Schema & created a relationship to 'match' the incoming domain address to the correct customer in my FM Customers table... My problem is this - I'm wanting the server to execute the send/receive script by schedule & i'm having a problem with my only supplemental field. The supplemental field I have in my shadow table uses the above relation to 'lookup/calculate' the desired 'destination' customer contract for the inbound email. When I execute this script on an FM client, the calculated field 'looks up' the value and the call is placed on the correct contract perfectly, however, when the server executes this script, the supplemental field doesn't lookup the required value automatically (which I need it to do by the time the script completes). Is there another way to do this?? I kind of understand why the server (not being an FM client) doesn't do this, however I've tried to add some additional script steps for it to 'force' the population of this field without having to manually 'fetch' the value from the other customer table each time. Script steps i've tried are various refresh/flush looked up values etc I hope this is clear? Any help appreciated. Matt Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6172 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 accountSign in
Already have an account? Sign in here.
Sign In Now