cmulgrum Posted September 27, 2007 Share Posted September 27, 2007 I have a database running on fm server 8.5. I want to create a local fm 8.5 db that calculates values based on field values on the server side. I've created a local file and created a reference to the server side table. Then I created a relationship between the server side field (itemnumber) and the local field (itemnumber). The purpose is reporting only and I don't want to modify the server side. The report output will be the creation date of the server side record and left(itemnumber,10)...itemnumber being the field on the server side database. I appreciate your suggestions. Craig Link to comment Share on other sites More sharing options...
Inky Phil Posted September 27, 2007 Share Posted September 27, 2007 I might be missing something here but I am not too sure what you want to know. Phil Link to comment Share on other sites More sharing options...
cmulgrum Posted September 27, 2007 Author Share Posted September 27, 2007 Serverside Database table (ArtTable)has Itemnumber and CreationDate. In a local FM file, I want a report that shows me Itemnumbers for a creationdate range. Additional fields would break up Itemnumber into 3 fields: Base:left most 10 characters. Color: mid(11,3) Size: right most 2 characters. I don't want to modify the app on the server side...only want to refer to the server tables... Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6148 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